Viewing 15 posts - 1 through 15 (of 286 total)
hey Ken .. wishing you a safe and faster recovery. Prayers for your well being !
July 8, 2020 at 2:25 am
Any downsides in performance that is actually encountered when patches are applied ?
January 16, 2018 at 10:08 am
Enable trace flag 1448. That will help replication configured with AG.
September 11, 2017 at 8:59 am
June 5, 2017 at 3:47 pm
For future visitors, you can use https://dbatools.io/ - its powershell based tool that helps migrate entire instance or selected databases from one server to another including everything - linked servers,...
August 16, 2016 at 10:07 am
Since i have this problem in a regular basis, i decided to make a simple script to minimize this problem.
January 27, 2016 at 2:11 pm
dgmueller (12/17/2015)
Msg 170, Level 15, State 1, Line 71
Line 71: Incorrect syntax near 'max'.
Msg 156, Level 15, State 1, Line 87
Incorrect syntax...
December 17, 2015 at 11:11 am
dave-L (11/24/2015)
November 30, 2015 at 7:57 am
Dathuraj Pasarge (2/9/2015)
Comments posted to this topic are about the item <A HREF="/scripts/Database+Migration/121942/">SQL Database Migration :Lower version of SQL Server to Higher version</A>
>> What if we have to migrate...
February 18, 2015 at 12:45 pm
Rudy Panigas (9/29/2014)
SQLQuest29 (1/2/2014)
Highly suggest to look into : SQL Server & Windows Documentation Using Windows PowerShell[/url] by Kendal Van DykeIt collects much more info and is flexible.
Why would I...
September 30, 2014 at 11:03 am
Contrary to the title, the query does not show the indexes.
Below is an enhanced version (courtesy of Aaron Bertrand)
;WITH src AS
(
SELECT
...
May 27, 2014 at 10:31 am
akhamoshioke (4/22/2014)
Comments posted to this topic are about the item <A HREF="/scripts/transaction_log/109527/">vlfs_Count_for_Each_Database</A>
why are you using undocumented sp_msforeachdb ? There are better ways of doing it.
May 6, 2014 at 9:10 am
rnithish (1/1/2014)
January 2, 2014 at 8:36 am
Highly suggest to look into : SQL Server & Windows Documentation Using Windows PowerShell[/url] by Kendal Van Dyke
It collects much more info and is flexible.
January 2, 2014 at 8:30 am
Sean Smith-776614 (12/11/2013)
You could also do something like this:
WITH CTE AS
(
SELECT
1 AS number
UNION ALL
SELECT
X.number + 1 AS number
FROM
CTE X
WHERE
X.number + 1 <= 100
)
SELECT
REPLICATE ('|', X.number) + REPLICATE ('.', 100...
December 12, 2013 at 10:04 am
Viewing 15 posts - 1 through 15 (of 286 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy