Viewing 15 posts - 37,381 through 37,395 (of 49,566 total)
July 29, 2009 at 12:54 am
Jan Van der Eecken (7/28/2009)
Why are you Vaalies always picking on us? :angry: Just coz we don't pick up the phone before 9AM?
Cause you're so laid back you won't...
July 28, 2009 at 4:05 pm
Startup procs have to be in the master database. They cannot be in any other DB. Bear in mind that, at the point that the startup procs run, the other...
July 28, 2009 at 10:03 am
mtassin (7/28/2009)
Consistency checks and index rebuilds I'd agree with... but apparently executing multiple backups seperated by ;'s will work too 🙂
Depends how much logic you're building into your backup routine.
July 28, 2009 at 9:48 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
July 28, 2009 at 8:35 am
Iron Chef SQL (7/28/2009)
Is it possible to nest a cursor inside a cursor,
Yes.
if so why would anyone do so.
Good question...
July 28, 2009 at 8:35 am
Vishal Singh (7/28/2009)
Yup, I saw. What of it? It's a fairly standard corruption message saying that there's damage to the blob pages
I mean here is that error 8964 doesn't left...
July 28, 2009 at 8:28 am
Iron Chef SQL (7/28/2009)
I'm just curious why another fetch is needed. I tested your suggestion and it worked.
There has to be a fetch inside the while loop to get the...
July 28, 2009 at 8:26 am
Vishal Singh (7/28/2009)
My databases are on 2000 only where I believe there is no DATA_PURITY option available?
Please post SQL 2000-related questions in the SQL 2000 forums in the future. If...
July 28, 2009 at 3:23 am
manoj2001 (7/28/2009)
So please check in your procedure wherver you are importing data into database.
It's not possible to insert out-of-range values via stored procedures. The SQL query processor will catch that....
July 28, 2009 at 3:20 am
Vishal Singh (7/28/2009)
Additionally, Look on to the error message Its Error 8964:
Yup, I saw. What of it? It's a fairly standard corruption message saying that there's damage to the...
July 28, 2009 at 3:14 am
Vishal Singh (7/28/2009)
July 28, 2009 at 3:12 am
sys.dm_db_index_usage_stats only holds info since the last start of SQL Server
July 28, 2009 at 1:24 am
Please post the procedure, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
First thing I'd suggest, try to get rid of that while loop. Looping in SQL is slow...
July 28, 2009 at 1:16 am
Viewing 15 posts - 37,381 through 37,395 (of 49,566 total)