SQLRNNR

Forum Replies Created

Viewing 15 posts - 5,131 through 5,145 (of 19,560 total)

RE: findout Database Corruption

Here is an article about alerts you can configure about corruption.
http://www.sqlsoldier.com/wp/sqlserver/day10of31daysofdisasterrecoverymonitoringforcorruptionerror
Do you have checkdb jobs configured to run on a regular basis?
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

January 20, 2013 at 11:22 pm

#1579090
RE: How to manage log space issue, when you have more than 1 log file for a particular database?

There is possibly an impact on logshipping. If the primary and secondary are configured the same for files and file paths, the change will likely propagate to the secondary...
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

January 20, 2013 at 10:44 pm

#1579088
RE: MSSQLSYTEMRESOURCE NOT IN DATA DIRECTORY LIST

noel yu-371000 (1/20/2013)
If following those steps verbatim doesn't work, try this (http://www.sqlnotes.info/2012/01/06/new-way-to-relocate-resource-database/)
I tried executing the SQL script "select name, filename from sys.sysaltfiles where dbid = 32767" -- No...
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

January 20, 2013 at 10:41 pm

#1579086
RE: MSSQLSYTEMRESOURCE NOT IN DATA DIRECTORY LIST

If following those steps verbatim doesn't work, try this
http://www.sqlnotes.info/2012/01/06/new-way-to-relocate-resource-database/
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

January 20, 2013 at 3:21 pm

#1579056
RE: MSSQLSYTEMRESOURCE NOT IN DATA DIRECTORY LIST

Did you start the server as the instructions say in step 7?
Start the instance of SQL Server in master-only recovery mode
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

January 20, 2013 at 3:14 pm

#1579054
RE: Need a backup script to get backup history status for the latest backup from all linked sql servers

sestell1 (1/19/2013)
I imagine everyone has their own approach to this.
Your approach of using linked servers will definitely work.
I use a C# application I wrote that lets me run...
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

January 20, 2013 at 2:58 pm

#1579050
RE: EOMONTH - 1

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

January 20, 2013 at 12:55 pm

#1579040
RE: How to manage log space issue, when you have more than 1 log file for a particular database?

Somebody probably created the second file as a spillover due to the space issues.
If the drive where the first log file was created is out of space, I would migrate...
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

January 18, 2013 at 9:15 pm

#1578927
RE: Are the posted questions getting worse?

Lowell (1/18/2013)
Brandie Tarvin (1/18/2013)
All we need is an actual Go Faster flag for the database, and everything will be FINE.
got your fix right here:
I need one of those
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

January 18, 2013 at 2:26 pm

#1578887
RE: Today's Random Word!

Ken Leeeeeeeeeeeeee
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

January 18, 2013 at 9:50 am

#1578780
RE: Number of Rows

Hugo Kornelis (1/18/2013)
paul s-306273 (1/18/2013)
In my naivete I'm thinking 'so what?'.
Is there a relevance to this?
That's what I though as well when answering the question.
I'm thinking the only value 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

January 18, 2013 at 9:19 am

#1578767
RE: Are the posted questions getting worse?

Brandie Tarvin (1/18/2013)
Evil Kraig F (1/17/2013)
Was ill for a week, miss anything of import?
The world came to an end, but the Doctor showed up and saved us all.
Didn't you see...
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

January 18, 2013 at 8:31 am

#1578750
RE: Vendor DB backup job help.

davidwarner (1/17/2013)
Problem is that the files will just build up if the filenames are different. This current setup allows the files to just roll over the next day.
And what if...
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

January 17, 2013 at 4:41 pm

#1578521
RE: CASE statement not working properly

Lisa Liel (1/17/2013)
Forgive me for wasting your time. Someone had started adding code into my proc with an IF statement, and hadn't closed it or commented it out. ...
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

January 17, 2013 at 4:40 pm

#1578520
RE: CASE statement not working properly

3 votes for the actual query.
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

January 17, 2013 at 4:04 pm

#1578506

Viewing 15 posts - 5,131 through 5,145 (of 19,560 total)