SQLQuest29

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 286 total)

Reply To: A Digital Wish Card for Ken

hey Ken .. wishing you a safe and faster recovery. Prayers for your well being !
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

July 8, 2020 at 2:25 am

#3768272
RE: Critical SQL Server Patches for Meltdown and Spectre

Any downsides in performance that is actually encountered when patches are applied ?
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 16, 2018 at 10:08 am

#1976006
RE: Replication Latency due to Selects running on the publisher

Enable trace flag 1448. That will help replication configured with AG.
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

September 11, 2017 at 8:59 am

#1958952
RE: Script DB Level Permissions v4

Andrew G - Monday, October 31, 2016 12:18 AM
Hi Steve, I use your script so much so I've got an update for you...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

June 5, 2017 at 3:47 pm

#1945502
RE: SQL Database Migration :Lower version of SQL Server to Higher version

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,...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

August 16, 2016 at 10:07 am

#1895709
RE: Avoid Transaction Logs volume from filling

Since i have this problem in a regular basis, i decided to make a simple script to minimize this problem.
Why not address the root of problem ? Is your database...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 27, 2016 at 2:11 pm

#1854822
RE: SQL server Service, Account, Trace Flag info

dgmueller (12/17/2015)
I ran this script and received the following errors:
Msg 170, Level 15, State 1, Line 71
Line 71: Incorrect syntax near 'max'.
Msg 156, Level 15, State 1, Line 87
Incorrect syntax...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

December 17, 2015 at 11:11 am

#1846631
RE: 512e (Advanced Format) Drives

dave-L (11/24/2015)
I've enabled trace flag 1800 on all replicas now and I'm still receiving this error. I did not restart the SQL service though. I place the trace flag in...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

November 30, 2015 at 7:57 am

#1842886
RE: SQL Database Migration :Lower version of SQL Server to Higher version

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...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 18, 2015 at 12:45 pm

#1778460
RE: SQL Server Documentor

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 Dyke
It collects much more info and is flexible.
Why would I...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

September 30, 2014 at 11:03 am

#1749229
RE: what tables and indexes are using the most memory in the buffer cache

Contrary to the title, the query does not show the indexes.
Below is an enhanced version (courtesy of Aaron Bertrand)
;WITH src AS
(
SELECT
...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

May 27, 2014 at 10:31 am

#1716759
RE: vlfs_Count_for_Each_Database

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.
Aaron Bertrand has a better way...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

May 6, 2014 at 9:10 am

#1711126
RE: Database design for daily log entries

rnithish (1/1/2014)
My project involves a business requirement to capture the activities that occur daily which might average to over 500 entries per day. Although SqlServer can handles billions of rows,...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 2, 2014 at 8:36 am

#1676940
RE: SQL Server Documentor

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.
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 2, 2014 at 8:30 am

#1676933
RE: Progress Bar Simulation on SQL Server

Sean Smith-776614 (12/11/2013)
Interesting.
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...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

December 12, 2013 at 10:04 am

#1673017

Viewing 15 posts - 1 through 15 (of 286 total)