Viewing 15 posts - 8,971 through 8,985 (of 19,560 total)
That is what your second query is doing.
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
August 18, 2011 at 5:20 pm
Each database master key should be backed up.
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
August 18, 2011 at 3:29 pm
Roy Ernest (8/18/2011)
Thread needs only 865 posts to hit 30K and I need 80 posts to hit 3K. Who will reach first,...
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
August 18, 2011 at 2:59 pm
Then I would start looking at what caused that much growth and that much log space to be consumed.
Here is an article to help with that.
http://www.sqlservercentral.com/articles/Log+growth/69476/
In the meantime, I would...
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
August 18, 2011 at 2:59 pm
I do it much the same as Gus.
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
August 18, 2011 at 2:56 pm
Sean Lange (8/18/2011)
Cool idea. Will have to add to my snippets.
Thanks - it actually made me think of an article to write
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
August 18, 2011 at 2:33 pm
FYI - we need only 866 posts to reach 30K
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
August 18, 2011 at 2:31 pm
Make sure the file is empty (move contents to another file) and then drop the extra files.
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
August 18, 2011 at 2:28 pm
Good to hear.
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
August 18, 2011 at 2:23 pm
Roy Ernest (8/18/2011)
When you have regular transaction log back up the chances of file growing out of proportion is very low. I guess that is why he asked.
Precisely.
What is...
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
August 18, 2011 at 2:21 pm
This should do it for you.
Declare @ColorType INT = 3
Select cp1.*
From ColorPlate cp1
CROSS APPLY ColorPlate cp2
CROSS APPLY ColorPlate cp3
Where cp1.colortype & cp2.colortype & cp3.colortype & @ColorType <> 0
Order...
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
August 18, 2011 at 2:19 pm
Yes, it grew by that amount.
Is this database in Full recovery? Are you backing up the transaction log?
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
August 18, 2011 at 1:44 pm
If either query produces a null, the division or multiplication of those fields will result in NULL.
Do either of the subqueries yield a null when you run them individually?
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
August 18, 2011 at 1:40 pm
This might be overkill, but it should get you everything you need.
http://jasonbrimhall.info/2010/03/19/security-audit/
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
August 18, 2011 at 1:33 pm
I could see that improving perf too. I would be careful in implementation and data change though.
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
August 18, 2011 at 1:07 pm
Viewing 15 posts - 8,971 through 8,985 (of 19,560 total)