Viewing 15 posts - 11,326 through 11,340 (of 19,560 total)
That will take a bit of extrapolation. If you know the data types, and by knowing the storage requirements for the data types you can begin calculating the space...
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
December 21, 2010 at 10:12 am
David Benoit (12/21/2010)
If the default trace is enabled (default is on) then you can use the script HERE [/url]to read through that and find out possibly.
That is an excellent recommendation.
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
December 21, 2010 at 10:00 am
This should get you going in the right direction. Make sure to read the linked articles in this link.
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
December 21, 2010 at 9:57 am
bitbucket-25253 (12/21/2010)
Anthony Johnson-756248 (12/21/2010)
Please provide data access controls that should be a standard to the database administration and data control areas of the community.
Your question is rather vague, however you...
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
December 21, 2010 at 9:53 am
Two options are:
1. Have Auditing enabled
2. Ask around to find out who changed 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
December 21, 2010 at 9:48 am
upstart (12/21/2010)
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
December 21, 2010 at 9:44 am
paul.knibbs (12/21/2010)
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
December 21, 2010 at 9:36 am
Thanks for continuing the series on this subject.
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
December 21, 2010 at 9:28 am
Roy Ernest (12/21/2010)
Our resident Kiwi, Paul being recongnized in the 12 days of Christmas series[/url].Well done Paul.
Yes - well done.
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
December 21, 2010 at 9:27 am
stewartc-708166 (12/21/2010)
SELECT CustomerName, CustRefNo, InvNo, invoiceamount
FROM #customer
UNION ALL
SELECT CustomerName, CustRefNo, 'Total' AS InvNo, SUM(invoiceamount) AS invoiceamount
FROM #customer
GROUP BY CustomerName, CustRefNo
ORDER BY 1,3
However, if this is 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
December 21, 2010 at 9:25 am
Kit G (12/21/2010)
(in the wee hours of the morning)
Been about 460 years or so (round to an even 500 for ease) since that happened!
Was...
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
December 21, 2010 at 9:22 am
I'm not a fan of these kinds of PITAs either. Can you add more conditions to your where clause inside the CTE? When I add the fieldid column...
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
December 20, 2010 at 11:34 pm
Do you need to have the results displayed just the same as what you displayed in your original post? Basically all the records for each customer and then 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
December 20, 2010 at 11:22 pm
Thanks for the question.
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
December 20, 2010 at 11:16 pm
I wonder how this statement holds up now.
I think SQL Server will see more and more 64-bit installations, but they'll be the minority of installations
I know that a vast majority...
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
December 20, 2010 at 11:14 pm
Viewing 15 posts - 11,326 through 11,340 (of 19,560 total)