Viewing 15 posts - 37,456 through 37,470 (of 49,552 total)
http://wiseman-wiseguy.blogspot.com/2009/01/redgate-sqlprompt-laughers.html
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2009 at 6:09 am
True as long as the OS isn't Vista or Server 2008. In both of those, builtin\admins no longer gets added as sysadmin. Also the case on all SQL 2008 installations.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2009 at 6:05 am
SQL 2008 has no problems with 2005 data files. It will convert them to 2008 format the first time they're attached. Once that conversion is done, there's no going back...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2009 at 2:51 am
SQL ORACLE (7/23/2009)
I got the same error except I was doing full backup. What is wrong then?
That error shouldn't be possible on a full. Diff, yes, log, yes.
Can you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2009 at 2:17 am
hugh.hemington (7/23/2009)
I do see something about "SQLAgent - Enabling/disabling Agent XPs" I'll look that up and see if it is an issue.
No, that's just the SQL agent procs getting...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2009 at 2:00 am
Several possibilities
Someone ran DBCC FREEPROCCACHE
A database was closed, taken offline or restored
An sp_configure was run. Some options flush the proc cache
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 1:43 pm
Login names are easy. Query sys.sql_logins. Passwords, on the other hand, are stored hashed within the master database and are not queryable.
Can you explain your problem in more detail?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 1:42 pm
DBA (7/23/2009)
can you update stats online in enterprise?
Statistics updates are always 'online'. There are no locks other than a schema stability lock taken by a statistics update so the table...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 1:40 pm
"I Am Legend"? The book, not the movie. Might be a little dark for the age that he is.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 12:50 pm
If you don't like QWERTY, try this - http://gizmodo.com/275582/
I love touchpads. Always use the touchpad on a laptop rather than packing a mouse and I have a fair-sized graphics tablet...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 12:00 pm
Try this for starters
http://sqlinthewild.co.za/index.php/2009/06/26/the-lazy-writer-and-the-checkpoint/
Recovery is only necessary when the DB has not been cleanly shut down, usually the result of an unexpected, sudden shutdown of the service or the server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 11:52 am
hugh.hemington (7/23/2009)
It's on a Server 2000 system, that is a domain controller running active directory (done to satisfy this stupid software), and it's just me using it.
Running SQL on a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 10:24 am
I use Logitech for both keyboard and mouse. Got the logitech G11 keyboard. Lovely keyboard, very large but quite flat and very soft touch. i barely have to touch the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 9:48 am
Grant Fritchey (7/23/2009)
Yeah, it does seem like a larger & larger percentage of the population are becoming dependent on a smaller & smaller percentage to just give them everything.
On the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 9:15 am
All indexes have statistics associated with them and those stats cannot be dropped. If you're manually creating stats, it's unlikely you'll get any benefit creating stats on the same column...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2009 at 8:43 am
Viewing 15 posts - 37,456 through 37,470 (of 49,552 total)