Viewing 15 posts - 6,781 through 6,795 (of 7,597 total)
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
You would need to code the time constraints in your WHERE clause. That is, bypass those rows yourself rather than trying to have SQL do it itself.
You might not...
February 11, 2013 at 1:08 pm
am wondering if the CASE requires all arguments to run against the exact same column?
No. CASE is very flexible: you can compare any columns you need to, in any...
February 11, 2013 at 10:03 am
Viewing 15 posts - 6,781 through 6,795 (of 7,597 total)