SQLRNNR

Forum Replies Created

Viewing 15 posts - 301 through 315 (of 19,560 total)

RE: Are the posted questions getting worse?

Sean Lange - Friday, March 24, 2017 2:53 PM
Lynn Pettis - Friday, March 24, 2017 2:18 PM
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 24, 2017 at 3:14 pm

#1934889
RE: Are the posted questions getting worse?

jonathan.crawford - Thursday, March 23, 2017 12:43 PM
Jeebus. How did I know I'd still find you guys here? All Hail The Thread!
Long...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 24, 2017 at 3:11 pm

#1934887
RE: Availability Groups Removed & Readded Database Problem :exclamation:

Brandie Tarvin - Thursday, March 16, 2017 4:23 AM
Ricky Valencia - Monday, March 13, 2017 9:00 PM
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 24, 2017 at 2:59 pm

#1934885
RE: DBCC is running from 5 days

Sue_H - Friday, March 24, 2017 2:30 PM
coolchaitu - Friday, March 24, 2017 12:38 AM
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 24, 2017 at 2:39 pm

#1934877
RE: DBCC is running from 5 days

I think a key indicator here is that a single job does the index maintenance on all databases and then proceeds to do the checkdb.
Which piece of the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 24, 2017 at 2:36 pm

#1934876
RE: Instance is under memory pressure. How to relieve from pressure

coolchaitu - Friday, March 24, 2017 10:58 AM
Eirikur Eiriksson - Friday, March 24, 2017 10:38 AM
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 24, 2017 at 2:30 pm

#1934874
RE: Query help

How are you arriving at the following values in your sample output script?
ReportBTotal
4
1
If it is supposed to be shared attributes, shouldn't those counts be...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 24, 2017 at 2:18 pm

#1934872
RE: Solution to avoid TEMP tables and CTE's

cphite - Friday, March 24, 2017 11:29 AM
2. Create a reporting table... Build a SQL job that uses your existing script to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 24, 2017 at 1:53 pm

#1934866
RE: Tlog backups - indicate no data change

That is the correct process, but the assumption on data change is not appropriate.
If you really want to ensure data is not changing, I recommend you take the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 24, 2017 at 1:48 pm

#1934865
RE: Trace Flag Status

david.gugg - Friday, March 10, 2017 7:20 AM
Will DBCC TRACESTATUS really show other users' session-based trace flag? The documentation reads to me...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 10, 2017 at 3:25 pm

#1932804
RE: Trace Flag Status

Stewart "Arturius" Campbell - Thursday, March 9, 2017 11:16 PM
Interesting question, thanks Steve.
However, the answer is not entirely correct:
trace#
Is the number...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 10, 2017 at 3:24 pm

#1932802
RE: Are the posted questions getting worse?

Hugo Kornelis - Thursday, March 9, 2017 1:44 AM
Neil Burton - Thursday, March 9, 2017 1:21 AM
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 9, 2017 at 11:31 am

#1932574
RE: How to determine Windows domain username when the user connected to SQL as SQL login with SA access

patrickmcginnis59 10839 - Thursday, March 9, 2017 6:27 AM
SQLRNNR - Thursday, March 9, 2017 12:09 AM
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 9, 2017 at 11:30 am

#1932572
RE: How to determine Windows domain username when the user connected to SQL as SQL login with SA access

patrickmcginnis59 10839 - Tuesday, March 7, 2017 12:41 PM
Given the critical level of importance related to permissions, one may think it...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 9, 2017 at 12:09 am

#1932456
RE: CPU Limits

Revenant - Tuesday, March 7, 2017 2:18 PM
Interrupting this thread to congratulate Steve on inclusion of Redgate tools in Visual Studio 2017...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

March 7, 2017 at 2:58 pm

#1932184

Viewing 15 posts - 301 through 315 (of 19,560 total)