Viewing 15 posts - 17,866 through 17,880 (of 22,202 total)
Yep, that was it. I was just curious what your thought processes were. I do agree.
March 30, 2009 at 7:47 am
GilaMonster (3/30/2009)
March 30, 2009 at 7:44 am
Interesting experiment.
The only way I know to affect compile time is to modify the query itself. The more complicated it is, the longer the compile time, the simpler, the quicker....
March 30, 2009 at 7:30 am
Impossible to say without more information, but probably you're getting table scans.
March 30, 2009 at 7:08 am
To do this in TSQL, you would need to use ad hoc queries and build your query as a string. SP_EXECUTESQL would be the best use.
Generally, something like this might...
March 30, 2009 at 7:05 am
Steve Jones - Editor (3/29/2009)
mohit is correct.Expiration is for overwriting backups, like if you had multiple ones in a file. (which is a bad idea)
I'm not saying you're wrong, in...
March 30, 2009 at 6:55 am
Just open up the Server Properties in SSMS. On the Processors page you can see how many processors you have available and set them to a particular affinity. I'd suggest...
March 30, 2009 at 6:54 am
When you say reads, do you mean STATISTICS IO in SSMS? Or you are referring to execution times? There is a difference there since SSMS is still showing milliseconds and...
March 30, 2009 at 6:49 am
I'm on LinkedIn, Plaxo & Facebook, but I probably don't open them more than once a week at the most and then for only a few minutes. Twitter on the...
March 30, 2009 at 6:24 am
Jeff Moden (3/29/2009)
Heh... it's all your fault, ya know? Our conversations about 3 months ago are what started it all.Thanks for the feedback, Grant.
Excellent. I'll take full credit for...
March 30, 2009 at 6:13 am
Excellent. Congratulations and good luck.
March 29, 2009 at 2:02 pm
Depending on how the data is distributed, what kind of data, etc., you might want to look into partitioning. This would allow most of the data to be online and...
March 29, 2009 at 2:00 pm
If you don't have windows authentication enabled anywhere, then you might be in trouble. There's no way to hack past the password (even if there was, this is not the...
March 28, 2009 at 6:12 am
I don't quite get the question either. If you read the foreign key constraint, it's going to tell you which table is constraining. From there you can either simply select...
March 28, 2009 at 6:11 am
Whatever this job is, I hope it's not too intrusive to the system since it sounds like it's going to be running 24/7. If you're inserting or updating data all...
March 28, 2009 at 6:09 am
Viewing 15 posts - 17,866 through 17,880 (of 22,202 total)