Viewing 15 posts - 961 through 975 (of 3,221 total)
yogesh.balasubramanian (10/3/2011)
I see a relavent article and it seems like table variable is much faster than temp table.:unsure: Confused on which one is better?
One item that the...
October 3, 2011 at 7:20 am
To answer your questions, Yes it is possible. That said what you have posted as your table definition(s) is not very clear. To get a tested response, can...
October 1, 2011 at 3:19 pm
Jack Corbett (10/1/2011)
I just hope I can honor that award the way that all the MVP's...
October 1, 2011 at 10:44 am
To help those who want to help you with tested code, please click on the first link in my signature block, read the article, and use the sample T-SQL code...
October 1, 2011 at 7:12 am
To be honest I do not know of any "Standard" test procedure as you are requesting. But you can do a great deal of "testing", checking for "good practices"...
September 30, 2011 at 2:49 pm
Sh*t happens. The question wasn't designed especially for that, but I expected it.
This one is just a small typo by Steve... and it keeps on going.
Apparently people like learning,...
September 26, 2011 at 3:28 pm
First of all let me state that without seeing your T-SQL statements I can not be sure I properly understand you question. That said I will suggest you read...
September 23, 2011 at 3:34 pm
A side effect of the order you have defined the nullable columns can have an effect on the size of the table, and you may want to take this into...
September 22, 2011 at 9:44 am
Ninja's_RGR'us (9/21/2011)
L' Eomot Inversé (9/21/2011)
LutzM (9/21/2011)
Gianluca Sartori (9/21/2011)
:-D:hehe:
Today we had an Oracle consultant (BI systems engineer, not a DBA) in our offices and I was discussing some (very serious) issues...
September 21, 2011 at 3:15 pm
Inertia is the name for the tendency of an object in motion to remain in motion, or an object at rest to remain at rest, unless acted upon by a...
September 21, 2011 at 11:42 am
jbwa
it was likely the QOD poser made a mistake
An incorrect assumption. If you had taken the time to read this entire forum you would have learned that...
September 20, 2011 at 11:18 am
SQL Kiwi
are written to the physical log file before checkpoint starts writing dirty data pages to the physical data file(s).
Thanks
physical log file / physical data -...
September 19, 2011 at 5:30 pm
Chad what adds to my confusion is items like:
Checkpoint will cause the log buffer to be flushed to disk (the current set of un-hardened log records).
And statements such as "the...
September 19, 2011 at 4:37 pm
Ninja's_RGR'us (9/17/2011)
Now all I know about Oracle is how to speel it...
September 17, 2011 at 9:01 pm
Viewing 15 posts - 961 through 975 (of 3,221 total)