Viewing 15 posts - 3,916 through 3,930 (of 19,560 total)
Here is a product that covers just about the entire gambit for audit purposes...
http://www.beyondtrust.com/Products/PowerBrokerDatabases/
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
February 4, 2014 at 5:04 pm
Yes this is very possible but be concerned about some of the problems using Access as a front end could cause if not careful (new session created for each form...
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
February 4, 2014 at 5:01 pm
When the table is coming from a variable, the entire sql statement must be done via Dynamic SQL. It can be done, but you have to set your entire...
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
February 4, 2014 at 4:41 pm
David.Poole (2/4/2014)
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
February 4, 2014 at 4:37 pm
Igor Micev (2/4/2014)
Heavy load.
My approach would be like:
You can change your package to use the Foreach loop container, put a data flow task in the loop container and then...
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
February 4, 2014 at 4:32 pm
For the deletion of the files you could also use a Script Task. I find it to be more useful than the File system task in some cases.
If 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
February 4, 2014 at 4:16 pm
You would need to change your multi-tiered cursors to be a dynamic statement and execute that statement.
The statement (to get the date pieces - converting to dynamic will be an...
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
February 4, 2014 at 4:08 pm
Will the table name always be formatted as "Stats" + yyyy + mm?
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
February 4, 2014 at 3:18 pm
Have you tried to loop through the table and assign the "query" in the table to a variable, then execute sp_executesql with the variables etc?
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
February 4, 2014 at 2:48 pm
L' Eomot Inversé (1/20/2014)
raulggonzalez (1/20/2014)
Sure, but considering the results differ from 2008R2 Standard to Enterprise, if that was the latest version, it'd be still a problem... I've no 2012 Enterprise...
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
February 4, 2014 at 11:55 am
You can do that via SSRS, Performance Monitor, or by dumping the data into excel on regular intervals.
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
February 4, 2014 at 11:46 am
I am curious how many people destroy the old backups that belong to no longer existent databases or that are well past the retention policy.
From looking at a few hundred...
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
February 4, 2014 at 11:39 am
From the options listed I think a fair bit of logic could help deduce the correct answer.
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
February 4, 2014 at 11:36 am
toke
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
February 4, 2014 at 10:59 am
jiayi345 (2/4/2014)
Thanks for all of the responses. I have determined what was causing the growth which was caused by an application that was having issues.
Cool - 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
February 4, 2014 at 10:40 am
Viewing 15 posts - 3,916 through 3,930 (of 19,560 total)