Viewing 15 posts - 391 through 405 (of 459 total)
MarkusB (1/13/2009)
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
January 13, 2009 at 8:45 am
GSquared (1/13/2009)
get_sid is, as per the comment in the proc, only available within system procs.
Okay...hmm...I tried this workaround. I created a stored proc called my_sp_validatelogins with nothing really in...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
January 13, 2009 at 8:40 am
Most of our servers are 2005, but some are 2000. I'm only using 2008 to run the query across multiple servers simultaneously (eventually), but the issue is failing on...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
January 13, 2009 at 8:18 am
Gautam Saha (1/10/2009)
Thanks.I'm still not sure how to split up an existing 75GB file into
two 37.5GB files on the same (or different) filegroup.
Here's a real life example for a database....
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
January 12, 2009 at 10:57 am
majorbloodnock (1/12/2009)
Cheap, light, powerful. Pick any two.Sadly, there's always a trade-off somewhere.
Exactly...If you don't mind paying the extra coin, there are some powerful 10-12 inch laptops out there. Not...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
January 12, 2009 at 9:17 am
Dennis Stephani (1/2/2009)
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
January 2, 2009 at 10:09 am
...The temporary table can look through statistics where as the table variable has to simply scan the entire table every single time.
Hmmm...I get it. I guess the first rule...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
December 30, 2008 at 9:55 am
Richard Norris (12/30/2008)
Have a read of this: http://blogs.msdn.com/sqlserverstorageengine/archive/2008/03/30/sql-server-table-variable-vs-local-temporary-table.aspxShould help
Thanks Richard, it did shed quite a bit of light. I do have one followup on it though. If the...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
December 30, 2008 at 9:32 am
Steve Jones - Editor (12/29/2008)
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
December 29, 2008 at 11:57 am
dford (12/24/2008)
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
December 24, 2008 at 9:10 am
jacroberts (12/24/2008)
Shane Redding (12/24/2008)
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
December 24, 2008 at 7:18 am
Sigh...
The while loop I used was only a proof of concept, and was designed to show people the mechanics of breaking out of a cursor mindset. They are both...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
December 24, 2008 at 7:08 am
Because our company has two seperate QA and Dev departments staffed by competent people, any outside contractors, either hired for a week or two or for months on end, have...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
December 22, 2008 at 12:12 pm
Here's a scenario where I had to use both procedural and set-based solutions (although I did avoid cursors). I get a request from an analyst every week or two...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
December 22, 2008 at 8:08 am
I guess I object to cursors because of their awkward looking syntax more than anything, although their performance compared side by side with equivalent rewritten set-based or even conventional procedural...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
December 22, 2008 at 7:46 am
Viewing 15 posts - 391 through 405 (of 459 total)