Viewing 15 posts - 6,601 through 6,615 (of 7,418 total)
I understand English may not be your first language, so I won't criticize any of those aspects of your post. I've tried learning a foreign language and know how...
February 13, 2013 at 10:34 am
Remember, SQL has to build a single plan ahead to time to cover any value. It doesn't look at the value of the variable when building the plan.
But at...
February 13, 2013 at 10:23 am
Maybe an empty value/string of '' is somehow getting passed to that column? An int of '' is set to 0.
February 13, 2013 at 10:19 am
russell-154600 (2/13/2013)
Please put all of the US Presidential elections and their results into...
February 13, 2013 at 10:14 am
Given that the q said "why should they not be prefixed", I think it's OK. It shouldn't be done because it does slow down name lookup for those objects,...
February 13, 2013 at 10:10 am
ALTER DATABASE MODIFY FILE ( NAME=logifcalfilename, SIZE=newsize )
No special considerations required.
If you don't have IFI set on, it may take a while, depending on how much you increased the size.
February 13, 2013 at 9:58 am
Michael Valentine Jones (2/12/2013)
ScottPletcher (2/12/2013)
Michael Valentine Jones (2/12/2013)
ScottPletcher (2/12/2013)
Michael Valentine Jones (2/11/2013)
ScottPletcher (2/11/2013)
Michael Valentine Jones (2/11/2013)
ScottPletcher (2/11/2013)
ScottPletcher (2/11/2013)
...
I haven't been in any business that worked with dates before 1900, but...
February 12, 2013 at 2:32 pm
Michael Valentine Jones (2/12/2013)
ScottPletcher (2/12/2013)
Michael Valentine Jones (2/11/2013)
ScottPletcher (2/11/2013)
Michael Valentine Jones (2/11/2013)
ScottPletcher (2/11/2013)
ScottPletcher (2/11/2013)
...
I haven't been in any business that worked with dates before 1900, but if yours did, then...
February 12, 2013 at 1:01 pm
The first format is definitely preferable, although I prefer checking the variable first to give SQL as much chance as possible to short-circuit (bypass) the second comparison:
WHERE (@seq IS NULL...
February 12, 2013 at 10:21 am
nsmith 8448 (2/12/2013)
One of the requirements is to create primary and foreign keys in the tables.
Is it acceptable to add the Emp_Id column to each table and use that as...
February 12, 2013 at 10:16 am
akshay.pawar123 (2/11/2013)
GilaMonster (1/9/2013)
ScottPletcher (1/9/2013)
If SQL needs only key column(s), why does it read all the leaf pages of the table as well?? That's an incredible waste of I/O.
The...
February 12, 2013 at 8:07 am
Michael Valentine Jones (2/11/2013)
ScottPletcher (2/11/2013)
Michael Valentine Jones (2/11/2013)
ScottPletcher (2/11/2013)
ScottPletcher (2/11/2013)
...
I haven't been in any business that worked with dates before 1900, but if yours did, then that would be a...
February 12, 2013 at 8:01 am
Michael Valentine Jones (2/11/2013)
ScottPletcher (2/11/2013)
ScottPletcher (2/11/2013)
...
I haven't been in any business that worked with dates before 1900, but if yours did, then that would be a relevant concern for you....
February 11, 2013 at 4:09 pm
Sean Lange (2/11/2013)
DON'T use things you don't need, like the BEGIN and END for the proc itself - completely unneeded and doing nothing but cluttering up the screen.
Actually begin...
February 11, 2013 at 4:05 pm
For best performance,
Cluster the table by
LAST_DAY_OF_MONTH
and not the dopey identity column. If you still need the identity (??), you can leave it as the nonclustered pk.
February 11, 2013 at 1:12 pm
Viewing 15 posts - 6,601 through 6,615 (of 7,418 total)