Viewing 15 posts - 4,921 through 4,935 (of 19,560 total)
Data source is the same thing. If you delete a datasource, the record should get removed.
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, 2013 at 11:45 pm
Run backups with checksum
Perform Regular Checkdb (you can do that before or after your backup jobs - but it depends on your environment as to when and how you do...
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, 2013 at 11:32 pm
The record is removed if you delete the subscription.
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, 2013 at 11:28 pm
Have you checked that the backup path is available and that the service account has permissions to that path?
It looks like a bad path specified in your maintenance plan as...
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, 2013 at 11:27 pm
If you are an hourly employee, then if they expect you to work extra hours - they should expect to pay for it. It's a lot of difference between...
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, 2013 at 11:23 pm
Best practice is to backup your database and transaction log as required by recovery objectives put forth by the business.
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, 2013 at 11:20 pm
Thanks Ron.
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, 2013 at 11:15 pm
Lynn Pettis (3/10/2013)
GilaMonster (3/10/2013)
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, 2013 at 11:11 pm
Try this
If not exactly what you need, it should get you some ideas at least.
select job_name, MAX(run_datetime) AS run_datetime, MAX(run_duration) AS run_duration,t.stop_execution_date
from
(
select job_name, run_datetime,t.stop_execution_date,
...
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, 2013 at 11:06 pm
Good to hear. Thanks for the feedback.
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, 2013 at 10:49 pm
Michael Valentine Jones (3/8/2013)
I suggest not giving people permissions to do backups, ands setup a job they can execute that does the copy only backup.
This would be my inclination as...
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, 2013 at 8:43 pm
Fraggle-805517 (3/9/2013)
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, 2013 at 8:23 pm
Jeff Moden (3/9/2013)
masoudk1990 (3/9/2013)
I recognized if we store an image in binary type in SQL SERVER they take more space. For example a 700kb image take about 900kb space.
With this...
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, 2013 at 9:09 am
Jeff Moden (3/9/2013)
Siobhan Perricone (3/8/2013)
I got asked to not use a cursor for a loop that I'm working on so I grabbed the code here:http://www.sql-server-performance.com/2004/operations-no-cursors/
To emphasize what Gail has stated,...
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, 2013 at 8:24 am
Then again, maybe a little more description on what you seek.
Are you just trying to eliminate dupes in your output, or eliminate dupes from the table?
If you are trying 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 9, 2013 at 8:16 am
Viewing 15 posts - 4,921 through 4,935 (of 19,560 total)