Viewing 15 posts - 106 through 120 (of 726 total)
It's sometimes used to make backups more manageable in a warehouse as well, as the partitions can reside in separate databases (or even separate servers, in which case it's a...
September 11, 2007 at 9:02 pm
That doesn't override the need for a sample of your data.
I'd personally like to see 3-5 rows of data as it appears in your file (feel free to replace any...
September 11, 2007 at 12:58 pm
Cool, I get to misuse Parsename for two different issues in the same day.
DECLARE
@GDate varchar(10)
SET
...
September 11, 2007 at 10:50 am
You didn't answer the questions regarding execution plans.
September 11, 2007 at 10:17 am
September 11, 2007 at 10:16 am
As Adam said, look at the execution plans on both servers.
Assuming that everything else is equal, I'd guess a parameter sniffing issue.
September 11, 2007 at 6:44 am
If, and only if, the OP really wants to do something similar to what I outlined (I am not aware of any other common use for this type of IP...
September 10, 2007 at 8:12 pm
Many IP-range lookup type databases (such as tying IP to country) convert IPs into long decimal numbers and then take the passed decimal and do a BETWEEN with two other...
September 10, 2007 at 2:47 pm
Your idea is bad. If you lose a bet, you pay up.
Even attempting to get off on a technicality won't work for you in this case.
September 10, 2007 at 10:43 am
It depends.
I'm starting to think that maybe a good book is what you need, as you are asking many questions that don't have a hard and fast answer, because they...
September 10, 2007 at 10:34 am
My answer was just an attempt at a humorous method of telling you that you lost. As MarkusB stated, it's quite possible. You need to keep in mind that there's...
September 10, 2007 at 10:31 am
"SELECT *" will return all columns from the table, while the other query will only return the "eno", "ename", and "salary" columns, no matter how many columns the "emp" table...
September 10, 2007 at 10:27 am
It depends.
Some three table queries run far faster than some two table queries. How the tables and indexes are designed and defined, as well as the coding itself, has a far greater...
September 10, 2007 at 10:24 am
As many as you need?
If you're asking for the maximum, I believe it's 256 in SS 2000.
September 10, 2007 at 10:12 am
What are you going to have as the theme for this party that you're going to be putting on for your cow orkers?
Sorry.
September 10, 2007 at 10:08 am
Viewing 15 posts - 106 through 120 (of 726 total)