Viewing 15 posts - 3,571 through 3,585 (of 7,168 total)
I assume you have autogrow enabled on your log file. Check the default trace to see when it grew, that can help establishing a timeframe of when the log bloat...
July 16, 2012 at 1:26 pm
lawson2305 (7/16/2012)
I run a tran backup and shrink every day. I append the backup daily except...
July 16, 2012 at 1:23 pm
I just tested SSIS 2008 against a 2008 R2 instance and the Rebuild Index Task picked up, rebuilt and therefore enabled a disabled index in my database.
Please post back...
July 16, 2012 at 12:27 pm
No. A REBUILD will rebuild the index thereby enabling it.
Check that the Rebuild Index Task is not skipping the disabled indexes.
July 16, 2012 at 12:18 pm
ananda.murugesan (7/16/2012)
DBCC UPDATEUSAGE corrects the rows, used pages, reserved pages, leaf pages and data page counts for each partition in a table or index.
DBCC CHECKDB with...
July 16, 2012 at 12:03 pm
chewychewy (7/16/2012)
Am new to profiler.
For example, I have this set up: (client side tracing)
Host A: SQL Server 2005 Production Database
Host B: Profiler GUI started and running to capture required...
July 16, 2012 at 11:46 am
Perry Whittle (7/15/2012)
or you could join msdb.dbo.sysjobs to master.sys.server_principals like so
SELECTj.name AS JobName
, sp.name AS JobOwner
FROM msdb.dbo.sysjobs j INNER JOIN
master.sys.server_principals sp ON j.owner_sid = sp.principal_id
Be careful. Jobs owned by logins...
July 16, 2012 at 11:08 am
Here is a SQL Prompt snippet I use regularly:
SELECT sdb.name AS DatabaseName,
bus.recovery_model AS RecoveryModel,
...
July 16, 2012 at 10:21 am
That single line of PowerShell is a "resumé-generating-event". DO NOT RUN THIS LINE IN YOUR ENVIRONMENT IF YOU WANT TO KEEP YOUR JOB. Wiping SID history for every...
July 16, 2012 at 10:05 am
One place I worked use the term "Code Drop" to mean exactly that, a synchronized deployment of database code and however many applications relied on the database changes.
July 16, 2012 at 9:52 am
You could use Server-side Trace (i.e. an unattended Profiler session, do not use Profiler for this), or a third-party tool like RedGate SQL Monitor that has query performance monitoring functionality.
July 16, 2012 at 9:40 am
Heh, not sure I have been banging my head, just picking up some breadcrumbs here and there. I really need to get my virtual lab off the drawing board. Being...
July 16, 2012 at 9:27 am
schleep (7/15/2012)
I don't want logins for individuals at all; they should have access by way of their...
July 15, 2012 at 8:38 pm
If you're going to use trace flags I would recommend 1222 over 1204. 1222 will write deadlock graph info to the SQL Server error log but you won't see valid...
July 15, 2012 at 9:03 am
Viewing 15 posts - 3,571 through 3,585 (of 7,168 total)