Cleanup SQL Server Query Store Data After Database Restore
In this tip we look at how to cleanup the SQL Server query store after a database has been restored to ensure that query store starts data collection starts fresh.
2019-01-30
2,074 reads
Cleanup
Custom cleanup procedure for backup files
There are times when maintenance plan is too simple to do the job, and SSIS is unreachable for you. Here is a simple stored procedure to help you.
2009-11-05 (first published: 2009-10-09)
1,510 reads
Case Cleanup Function
Capitalize the first letter of each new word in the string (clean, efficient, and easy to modify).
2008-08-14
320 reads
2005-05-16
RE: Strategies for historical data tables
Slowing down...how slow? You could look at building a cube, might be overkill. I wouldnt consider 2 mil rows a lot. What size server? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-27
RE: public fixed DB role - a pain?
I can be in control over this. So I plan to dissipate ALL public power especially after I read "lockdown script", very inspiring from www.sqlsecurity.com read the script (that is free to download)it is interesting and lets you block the most important sp rights for public. Regards
2003-06-27
1 reads
RE: Database can't be reached by users
I'm the job owner. I've stopped and restarted all services several times during the day while trying to solve this. I'm going home soon (hopefully). I'm running the backups as me so I have backups working. I just need to find out why they won't run under DBO and why my one database is inaccessable […]
2003-06-26
1 reads
RE: Output to file
The download butkton at the bottom of the page. It's an extended proc which you "install" on SQL. The explination he gives makes it easy to use. I have used it and not had any problems. It runs under SQL so no, it is not a virus or anything harmful. If you want to dump […]
2003-05-28
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers