Viewing 15 posts - 9,451 through 9,465 (of 22,214 total)
The role of the DBA is generally considered somewhat vital to the organizations that hire one. So, in general, they don't hire people with zero experience. There are exceptions to...
October 7, 2013 at 7:30 am
Jack Corbett (10/7/2013)
Jeff Moden (10/5/2013)
Speaking of "unbelievable", is [font="Arial Black"]THIS[/font] all that a Master's degree + the ability to walk on water is worth nowadays?
In some parts of...
October 7, 2013 at 7:25 am
Yep. This site is very good. You can also look to ask.sqlservercentral.com for simple question/answer style of issues. You can also look to Simple-Talk.com to for in-depth articles.
October 7, 2013 at 6:27 am
What about just putting the create procedure scripts into the same set of commands that restore the database. Assuming you're using SQL Agent to automate the execution of the restores,...
October 7, 2013 at 6:26 am
2gb is a VERY small amount of memory for SQL Server. How much data are you trying to retrieve? How big is the query? The message you're receiving is very...
October 7, 2013 at 6:21 am
Backups and restores.
Oh, those weren't on the list. I'm going to support Gail's answer. If you spend more time building and designing systems, having a working knowledge of how the...
October 7, 2013 at 6:17 am
Excellent editorial Steve.
At my previous employer we spent years and interviewed hundreds of people trying to find qualified DBAs. This story, someone knows a few things and repeats them for...
October 7, 2013 at 4:29 am
What Gail said.
But, if you really want to avoid adding too much additional overhead to the system, then instead of a trace, I'd look at extended events. They're much more...
October 7, 2013 at 4:11 am
I would not suggest turning it off, no. You can add additional traces if you need them, but the default trace captures a basic set of information about what's happening...
October 5, 2013 at 5:30 am
I would suggest focusing first on wait stats to understand what is causing the server to run slow. But, if you want to know if you're out of memory, going...
October 5, 2013 at 5:24 am
GilaMonster (10/4/2013)
I mean the normal dictionary definition of the word.An OLTP system does not automatically have low PLE from being a OLTP system.
Absolutely not. We had OLTP systems with insanely...
October 4, 2013 at 3:20 pm
Jeff Atherton (10/4/2013)
SQLBill (9/30/2013)
Guru's Guide to Transact-SQL by Ken Henderson is my most-read book on SQL Server.-SQLBill
Haven't heard of this one before and all I can find is a version...
October 4, 2013 at 8:55 am
There are multiple causes for this message. Without more information, it's really hard to suggest what it might be. Have you checked the error logs on the server to see...
October 4, 2013 at 4:33 am
Don't get too hung on page life expectancy. It's not a measure of performance really, but an indicator of certain behaviors within the system. I've seen servers that were performing...
October 4, 2013 at 4:10 am
Another approach is to use the queries in cache and the execution plans missing index hints to identify the queries that are called frequently or are actually running slow that...
October 3, 2013 at 12:07 pm
Viewing 15 posts - 9,451 through 9,465 (of 22,214 total)