SQLRNNR

Forum Replies Created

Viewing 15 posts - 211 through 225 (of 19,560 total)

RE: Unkillable session - alternatives?

Dird - Saturday, April 1, 2017 6:15 PM
SQLRNNR - Saturday, April 1, 2017 5:32 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

April 1, 2017 at 7:38 pm

#1936143
RE: How to archive old data from sql database

table paritioning is frequently used to meet this kind of requirement.
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

April 1, 2017 at 5:48 pm

#1936139
RE: Removing Table Partitions

lkennedy76 - Saturday, April 1, 2017 5:41 PM
the num_row says 0, I'll restore the database again and start over, I suspect I have...
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

April 1, 2017 at 5:43 pm

#1936138
RE: tempdb data and log file

Yes move the log.
Are all of your data files the same size? Are they large enough to support the reporting requirements?
If you still have contention with...
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

April 1, 2017 at 5:36 pm

#1936135
RE: Unkillable session - alternatives?

Those session transactions from December 2015 make me go :pinch:
Where was the single_user initiated from (ssms or some other app)? This wreaks of an orphand transaction from...
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

April 1, 2017 at 5:32 pm

#1936134
RE: Actifio?

If you do native backups and then just use actifio to backup the flat backups, then no impact on the native chain.
If you have a full + diff...
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

April 1, 2017 at 5:14 pm

#1936133
RE: SQL Server DBA Certification

Jeff Moden - Thursday, March 30, 2017 8:29 PM
SQLRNNR - Thursday, March 30, 2017 11:42 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

April 1, 2017 at 4:48 pm

#1936130
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Saturday, April 1, 2017 6:48 AM
Jeff Moden - Friday, March 31,...
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

April 1, 2017 at 4:46 pm

#1936129
RE: Removing Table Partitions

You can use this to help find your range values. You will only be able to merge one range at a time.

SELECT pf.name...
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

April 1, 2017 at 1:46 pm

#1936124
RE: Removing Table Partitions

alter partition function blah merge range blah (this is the range that was associated to the file you dropped).
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

April 1, 2017 at 11:01 am

#1936118
RE: Actifio?

tsduke - Friday, March 31, 2017 7:41 AM
We are in the middle of implementing Actifio as our backup strategy. Obviously as a...
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

April 1, 2017 at 10:57 am

#1936117
RE: Database backups Vs VM backups

Grant Fritchey - Saturday, April 1, 2017 2:47 AM
It's about the restore. The recovery. Can we do it? Consistently? Quickly? Accurately?
I want...
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

April 1, 2017 at 10:50 am

#1936116
RE: Proper way to remove columns from source

Phil Parkin - Friday, March 31, 2017 1:52 PM
I've read this thread through a couple of times and I'm still not sure...
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 31, 2017 at 3:28 pm

#1936088
RE: Embedded SQL Server 2008 Workgroup license mobility

Awesome sauce. Good luck.
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 31, 2017 at 1:02 pm

#1936063
RE: Grant Execute Permission on sp_audit_write

Does the user/login have any explicit denies? E.g. deny execute?
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 31, 2017 at 1:01 pm

#1936062

Viewing 15 posts - 211 through 225 (of 19,560 total)