Database File Move Etc
A stored procedure to generate database file moves along with Robocopy script and the attach / detach scripts
2016-04-20 (first published: 2016-04-04)
561 reads
move
move tempdb
For maximum performance, tempdb should be placed on a seperate disk. This script does all the work for you, except the restart!
2014-10-13 (first published: 2014-09-09)
1,467 reads
UP_COMPACTA_COPIA
I have several problems with my corporate network and therefore need to do all my backups locally, and to make matters worse, still use SQL Server 2005.
2011-10-17 (first published: 2011-09-30)
427 reads
RE: QOD
lepez, they are not visible any longer. We are looking to republish the questions and answers, so look for that soon.
2004-10-04
RE: One-step data scrubbing
It will depend on your setup but if you are the default setup for the English version then this should do the trick.SELECT datepart(mm,cast(replace(birth_date,'.','') as smalldatetime))Note: 'dec 12,2004' is understood as 12/12/2004. But 'dec. 12, 2004' will cause an issue. As long as all are the standard abbreviations you should be fine except needing to […]
2004-05-13
RE: SMTP Configuration - Need Help
Find out from your system or mail administrators the name (or IP address) of your SMTP server. If you're going to use SQLMail, read through this Knowledge Base article, as it presents a reasonable coverage of how to setup SQLMail: http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556 If you're going to use SMTP without using SQLMail and you want to mail […]
2003-08-24
RE: Is NOT EXISTS fast like EXISTS?
Best you're going to get is an INDEX SCAN. So, even with an index, it still has to go through the entire index and look for existence. I suppose theoretically, a non-clustered index would speed things up for NOT EXISTS queries if the value searched is in the index, since SQL Server can load more […]
2003-06-23
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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