Viewing 15 posts - 10,606 through 10,620 (of 22,213 total)
I would probably set up a job within SQL Agent that does the backup, running as sys admin, and then give the users permission to execute the job (which can...
July 30, 2012 at 5:46 am
Morning threadizens. I just deleted a couple of hundred emails from you lot. Did I miss anything really important in the last seven days?
July 30, 2012 at 5:01 am
I don't know of a book just on the disk sub-system, but the disk sections of Kalen Delaney's book, SQL Server Internals, is absolutely a must-read. Also Chris Bolton's book,...
July 20, 2012 at 7:48 am
SQLSACT (7/20/2012)
Grant Fritchey (7/20/2012)
July 20, 2012 at 5:25 am
It depends on two things, neither one database size, transactions in transit and your connection speed. So, no, you should see reasonably fast transitions depending on what's going on with...
July 20, 2012 at 5:10 am
The signal wait is just time waiting on the processor. It's an indication that for any given type of wait, you may, depending on what percentage the signal wait takes...
July 20, 2012 at 5:06 am
Probably should be moved to the "Anything that is not about SSC" forum, but that's Steve's call.
I was drafted/volunteered. I was working for a dot com startup as a developer....
July 20, 2012 at 5:03 am
Also remember that recompile might play a factor. It's reduced or eliminated with table variables, but it's something you'll have to deal with when using temporary tables. Remember, there are...
July 20, 2012 at 4:58 am
Not much to add. I'd start with Gail's articles. Once you're going, my books can help. Also, performance issues can be from causes other than queries (although that's near the...
July 20, 2012 at 4:56 am
The DMOs related to query performance are basically, what is absolutely executing right now, sys.dm_exec_requests, or, an aggregate of queries that have executed for the queries currently in cache, sys.dm_exec_query_stats...
July 20, 2012 at 4:51 am
Test all three and see which one does what you want in the most efficient manner.
Probably, I'd look at #3 first, but it really depends on what the execution plan...
July 20, 2012 at 4:48 am
Devesh_Srivastava (7/19/2012)
If the size of databases are very large and you are using backup compression technique then you should not include the Verify Backup option in the Backup job as...
July 20, 2012 at 3:23 am
Query Tuning
Execution Plans
Backups
Monitoring
Development & Deployment processes
Deadlocks
Parameter sniffing
Rinse and repeat
July 20, 2012 at 3:21 am
Ah, I don't think it displays status for that recovery process. I think you'll have to wait. Sorry.
July 18, 2012 at 8:14 am
I have several different versions of this type of query in this article[/url]. Take a look. I think you'll find something to help.
July 18, 2012 at 7:59 am
Viewing 15 posts - 10,606 through 10,620 (of 22,213 total)