Viewing 15 posts - 1 through 15 (of 16 total)
1. Where are you running the stored procedure version from? Management Studio? The web application?
SP is run from SQL Management Studio
2. Which environment are you using...
July 27, 2009 at 12:57 am
Many thanks for the reply. Maybe my first post wasn't clear - apologies.
The "doing stuff" that I mentioned in the previous post is computationally intensive and hence the choice...
July 26, 2009 at 11:35 pm
We use litespeed and I can honestly not say a bad word about it... it does exactly what it says on the tin!
March 4, 2004 at 8:00 am
We used to do this, a couple of years ago so this problem might have already been fixed.
If a single database backup file goes over a limit (I seem to...
March 4, 2004 at 12:35 am
No - you will automatically recieve the public beta in your MSDN collection. But the public beta is beta 2 - beta 1 is not available to anyone outside a...
March 3, 2004 at 12:30 am
After talking to a bunch of SQL MVP's at a recent conference as far as they could tell beta 2 would be around June time
March 2, 2004 at 12:34 am
You mention you drop all the indexes... including the ones on t2?
I wouldn't turn off AutoGrow until you have examined the number of Database growths in Profiler.
Also look for SP...
December 15, 2003 at 9:31 am
Truncate table also resets identities
December 15, 2003 at 9:02 am
Also worth checking any other usage of SQL instance and/or server in general.
What about fragmentation of indexes?
Has the query plan changed? Are your statistics now out of date?
December 15, 2003 at 8:00 am
Foreign keys do impact performance on inserts and updates on all RDBMs.
Every time the data changes a sub-query has to be run on the parent table to ensure that the...
December 12, 2003 at 12:54 am
Finally tracked this one down....
The service account had been added to the Guest group on the server - for some reason this caused this error. Wierd!
December 11, 2003 at 7:56 am
select * from syscomments where text like '%product%'
December 8, 2003 at 8:23 am
Thanks for responding. The account that both the SQL Server service and the SQL Agent service are running under is a sysadmin. I have tried granting EXEC permissions...
November 17, 2003 at 1:34 am
Hi there,
Thanks for responding. The SQL Agent is using the same service account as the SQL Server service. This is a domain account as recommended in BOL.
It was...
November 14, 2003 at 12:35 am
Surely if I create the clusterd index - defrag it, then drop it, the data will first off all be copied to a bunch of index pages (in the clustered...
November 12, 2003 at 1:59 am
Viewing 15 posts - 1 through 15 (of 16 total)