Viewing 15 posts - 37,411 through 37,425 (of 49,566 total)
luckysql.kinda (7/26/2009)
Now here uid=8 determines who is the owner of this table.
Not in SQL 2005 and above it does not. It shows what schema the table is in. In SQL...
July 27, 2009 at 10:11 am
No idea offhand what the base table is, but the system view is sys.sql_modules
July 27, 2009 at 10:10 am
A database snapshot can only be created of an online database, or a mirror database that is in the synchronised state. A database that's in the restoring state cannot have...
July 27, 2009 at 10:05 am
How big are these indexes? How many pages?
July 27, 2009 at 10:04 am
The entire of cache won't be cleared (that would be a bad thing). Just the plan of the object dropped will be marked as invalid and discarded.
July 27, 2009 at 9:27 am
If you want specific optimisation help, please read this first http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 27, 2009 at 8:54 am
Grant Fritchey (7/27/2009)
Man, I'm clearly not doing things correctly.
Guess I'm more persuasive than you are... 😉
I've had to present twice a year for the last three years. I have...
July 27, 2009 at 8:51 am
Steve Jones - Editor (7/27/2009)
And apparently you folks are getting ready for lunch. Enjoy!
Supper!
Mmmm, leftovers.... 😀
July 27, 2009 at 8:37 am
Steve Jones - Editor (7/27/2009)
I'd suggest that you try shorter presentations. The Orlando and Denver groups will do a 30 minute "opening" for new presentations or speakers.
I give potential...
July 27, 2009 at 8:35 am
In my experience, the first one is the hardest. Once people see someone who's usually in the audience giving the presentation, they're a lot more willing to try it. Until...
July 27, 2009 at 8:28 am
If I may suggest...
Look at optimising that, at minimum removing the while loops and breaking it up into smaller procs. 1300 lines is waaaay huge for a single stored proc.
July 27, 2009 at 8:12 am
Roy Ernest (7/27/2009)
July 27, 2009 at 8:09 am
Roy Ernest (7/27/2009)
I have been very busy setting up the Curacao SQL pass chapter. At last we are open to the whole world. 🙂
Woot. Congrats. Who you got lined...
July 27, 2009 at 7:50 am
Gaby A. (7/27/2009)
arthykannan (7/6/2009)
July 27, 2009 at 7:49 am
rsnow (7/27/2009)
Um, no offense, but Buddhists first of all don't use the term Buddhism;
What term do you use?
July 27, 2009 at 7:48 am
Viewing 15 posts - 37,411 through 37,425 (of 49,566 total)