Viewing 15 posts - 76 through 90 (of 98 total)
"Table Variables are more performant than temp tables because they don't use tempdb."
From my experience I have seen table variables still built into tempdb. Do some simple testing and you...
June 2, 2006 at 7:21 am
Thanks Steve, good info.
I rely more on a document that tells me what my people are best at. Then we can put them into the spot where they will succeed...
November 9, 2005 at 1:51 pm
This was a very practical lesson, will be used. Thanks!
October 24, 2005 at 7:27 am
Will a lot of the skills in this book transfer to SQL 2005? Or will I need another monster book for its replication set?
August 4, 2005 at 1:12 pm
Great job everyone. When one of these questions comes up and there is bantering over, I can really learn a lot just from everyones jousting and throwing sabers. It is just...
August 2, 2005 at 3:36 pm
In my experience it all comes back to design. If at design time you get everything right, keys and indexes should be very obvious. This really is not asteriod physics....
July 22, 2005 at 8:06 am
Hubie Brown, " And then the Gong went off"
July 21, 2005 at 8:19 am
Remember Gents this is databaseville. Nothing is ever as it seems, pull up a chair and stay a while.
July 15, 2005 at 7:23 am
One thing I am concerned with.
One of my job responsibilities is to peer review tsql code created by developers. I am currently very confident of noticing items that can be...
July 13, 2005 at 7:19 am
I bet ANSI-C developers think were all crazy. But....
((a + A) - B++) *b.... now thats crazy! 🙂
It is nice to know if we have to for some reason store...
July 8, 2005 at 8:27 am
On Source Control:
I have found using a db project in vstudio.net a workable SQL code source control solution. This is an ideal situation when you have non sql source and sql source, as...
July 7, 2005 at 8:08 am
Viewing 15 posts - 76 through 90 (of 98 total)