Viewing 15 posts - 3,796 through 3,810 (of 19,560 total)
I don't think it would be worth it.
Many employers pull the credit history these days and do make that judgement if there are big dings on the credit.
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 8, 2014 at 3:12 pm
Until clients and vendor are willing to tune their code, many problems will only be masked by hardware.
For a time. Then they'll reappear.
Getting clients and vendors to tune code 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
February 8, 2014 at 2:37 pm
I don't know if I'd prefer to see people in technology working only a few jobs during their careers, spending decades at each, or if we are better workers with...
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 8, 2014 at 2:25 pm
I like the change. I hope that more and more people will start to use it and provide some sort of feedback along those lines.
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 8, 2014 at 2:17 pm
My understanding of the requirements now is as follows:
You want to find the latest log backup in a series of backups that has not been restored to a different server
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 8, 2014 at 10:32 am
Since you are able to back this database up to a different volume it sounds like the drive that is failing might have some problems. This could be anything...
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 7, 2014 at 9:51 pm
@jeff and others,
You might be interested in this solution provided here.
http://sqlblog.com/blogs/merrill_aldrich/archive/2011/01/04/posh-y-sql-disk-space-monitoring.aspx
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 7, 2014 at 6:09 pm
nagkarjun1 (2/7/2014)
Lowell script worked like charm. modified little
SELECT r.name,dbs.DatabaseName
FROM master.sys.server_principals r
...
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 7, 2014 at 5:07 pm
Lynn Pettis (2/7/2014)
I have been home since Sunday afternoon and today is the first day it has been warmer than it has been at night back in Afghanistan.
Welcome Back
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 7, 2014 at 4:42 pm
That end date was one of the questions around the requirements that we already asked about.
How do you know that the end date should be 12/31 or 6/17 when there...
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 7, 2014 at 4:38 pm
Uh yeah. I'm in if Steve brings them to Summit to go with Kilt Day this year.
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 7, 2014 at 2:16 pm
One other thing about using the maintenance plans. There is a very important feature you can't do with regards to backups. The only means to perform a checksum...
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 7, 2014 at 2:14 pm
New Born DBA (2/7/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 7, 2014 at 2:02 pm
Evil Kraig F (2/7/2014)
"How would you fill a cup of coffee with...
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 7, 2014 at 1:53 pm
A more basic approach might be something like this
sp_MSforeachdb 'use ?; SELECT DB_NAME() AS DBName,name AS UName, type_desc AS Usertype
FROM sys.database_principals
WHERE type like ''[GUS]''
AND sid IS NOT NULL;
'
edit fix...
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 7, 2014 at 1:08 pm
Viewing 15 posts - 3,796 through 3,810 (of 19,560 total)