Viewing 15 posts - 31 through 45 (of 604 total)
I've only really used SQL Compare and SQL Data Compare and both tools are awesome.
Easy to use and can be absolute life savers!
September 26, 2013 at 9:35 am
Like a good few other posters, the database team handle the backups here.
Once on disk, infrastructure take over and make their necessary backups and also perform copies from the data...
September 20, 2013 at 9:20 am
Reorgs are definately better during the week. I think my script is set up to reorg over 10% and rebuild at 30%. The fill factors will make a...
March 1, 2013 at 1:51 pm
The answer is it depends. Killing a rebuild will take some time to release the locks and you will continue to suffer.
Do you run 24/7 or do you have...
March 1, 2013 at 10:08 am
Just don't union 2 x 1.3m row, 200 column wide CTE's in a view which is called very frequently. It bought tears to my eyes when I encountered this...
June 15, 2012 at 3:53 am
Interesting that this one came back around. I moved jobs earlier in the year. Most of the 9 steps were done within the first couple of weeks. ...
June 15, 2012 at 3:47 am
The project was un-canned and in the end we just stayed with traditional SQL Server replication.
Although we now have a client who wants their data replicated but doesn't want to...
May 12, 2011 at 4:26 am
To be honest, I've never tried something so elaborate!
In our environment, We have prohibited all access from desktops to production environments. The only way to connect to production is...
November 5, 2009 at 2:00 pm
Bru Medishetty (11/2/2009)
Krasavita (11/2/2009)
What should I do? how can I clean it?
You need to Shrink the Database.
Use DBCC SHRINKDATABASE or the Individual Data Files, using DBCC SHRINKFILE
Rather Use the Enterprise...
November 3, 2009 at 3:57 am
I think this should have been a multiple answer question!
Snapshot replication I agree with but I chose profiler which can also grind a heavy OLTP system to a complete halt...
October 11, 2009 at 5:09 am
If you have appended the backups in a single file, when you select the backup file, you will see all backups within the file.
If you only have two backups, you...
October 11, 2009 at 4:23 am
First of all, DTS is a SQL Server 7 and 2000 tool.
SQL Server 2005 has a much more advanced ETL tool called SSIS which would allow you to migrate data...
October 11, 2009 at 4:14 am
I'd say if you have uninstalled the application, it has not cleanly uninstalled.
Check Add/Remove programs or check the services to see if the application still resides. If it is...
October 11, 2009 at 4:06 am
Let me know if it fails.
Confidence! Love it! Nice script though. I'll take a copy of that one - could be usefull...Maybe one which you could submit...
October 3, 2009 at 1:36 pm
Viewing 15 posts - 31 through 45 (of 604 total)