Viewing 15 posts - 19,531 through 19,545 (of 19,560 total)
Every 24hrs? Developer related?
Ouch - but can sympathize.
Good Luck with that :crying:
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
July 1, 2009 at 10:53 am
Thanks for the script suggestion. I like the proposed script and concept.
Shrinking the file is of lesser concern to me right now.
The heart of the matter seems to be...
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
July 1, 2009 at 10:51 am
I get the reason "because the server OS needs it and it is Microsoft after all" approach.
My response is typically along the lines "uh-huh sure".
At least I don't get 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
July 1, 2009 at 10:34 am
I would like to get this filegroup down to a reasonable size (500MB seems very large but is what I was able to get my Dev and QA environments down...
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
July 1, 2009 at 10:32 am
shrinking only brings me back to the 11GB though. Total size of the filegroup is 19GB and all it will let me reclaim is the 8GB free 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
July 1, 2009 at 10:29 am
Monthly for patches - per SLA. This is insisted at the monthly frequency by the IT Team.
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
July 1, 2009 at 10:13 am
If you do not experience a high volume of transactions / or are backing up to tape - then it looks like your Backup Plan makes sense.
Do a full nightly...
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
June 22, 2009 at 12:41 pm
Page - 80's version of texting (who carries a pager these days?)
However, if the page is torn, then i don't know how to answer Gails 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
June 22, 2009 at 11:24 am
ROFLOL
Mirroring - Not really replication with or without consent - just cloning yourself.
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
June 22, 2009 at 11:17 am
Run tran log backups after completion of the full.
If you are running a nightly full, there is no need to do a diff that day with your databases being so...
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
June 19, 2009 at 2:05 pm
Why I'm going to code or fix code? 😎 ... I'm not getting paid for that! That's the developer job. Yes, the DBA should be smart enough to identify 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
June 19, 2009 at 10:52 am
This is accurate. If you login with 'sa', and then change the password - you must disconnect that session and login again with the new password
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
June 19, 2009 at 10:31 am
Torn page - I'm using Guerrilla Glue - better than duct tape or superglue - and has many more uses.
As for the coding questions. A DBA does have 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
June 19, 2009 at 10:27 am
With this being a highly busy OLTP configuration and drive C should be for system files - safest bet is Drive D for all files.
Better option would be to purchase...
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
June 18, 2009 at 6:16 pm
Which of the fields is the identity field? What are the datatypes for the remaining fields in your Key?
When comparing these queries, it is difficult to answer your 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
June 18, 2009 at 6:11 pm
Viewing 15 posts - 19,531 through 19,545 (of 19,560 total)