Viewing 15 posts - 16 through 30 (of 64 total)
If you can't change the recovery model and don't have space in your log file can you break down the package a bit.
Is it all just insert statements. Are you...
October 23, 2009 at 9:37 am
I think SORT_IN_TEMPDB only uses the tempdb when the index is created or when it is being rebuilt. It isn't used when quires are run against the index.
In what sort...
October 23, 2009 at 9:28 am
Hi
The script I have pasted below is one I use after clearing out and inserting a lot of data into a database.
It uses sys.dm_db_index_physical_stats to get the fragmentation of the...
October 23, 2009 at 9:18 am
Is it your log or data file that is growing too big.
If your not sure there should be a message in the SQL error Logs.
I would guess it is the...
October 23, 2009 at 9:10 am
You shouldn't have to do anything: make sure your system databases are backed up and if you like your users dbs too.
In effect your infrastructure team will tell the...
October 23, 2009 at 9:08 am
MelissaLevitt (10/18/2009)
October 20, 2009 at 7:28 am
Jack Corbett (10/19/2009)
October 20, 2009 at 4:56 am
okiftequar (10/15/2009)
Try this query, you can also modified in this...select * from msdb..sysjobhistory
order by run_date, run_time desc
for know more abt this, you can also refer onlinebook link...
http://msdn.microsoft.com/en-us/library/ms174997.aspx
Regards,
M.I.
This...
October 20, 2009 at 4:39 am
I'm sure you are right.
The only time I have used it was for this error:
Incorrect PFS free space information for page (1:105428) in object ID 60, index ID 1, partition...
October 14, 2009 at 9:55 am
What about restoring from a backup?
Repair_allow _Data_loss does not mean there has to be data loss though so your solution was probably fine.
October 14, 2009 at 7:43 am
I agree with dave.farmer.
This wasn't a SQL knowledge question but more of a practical joke
October 14, 2009 at 7:37 am
Thanks Deepak
Just had the same problem on one of our servers and your blog fixed it for me 🙂
October 6, 2009 at 3:09 am
Do you know what SQL Server is doing during the hour or so when disk utilization goes up high?
Have any other applications been installed on the server - eg anti...
September 30, 2009 at 4:29 am
Viewing 15 posts - 16 through 30 (of 64 total)