Viewing 15 posts - 3,571 through 3,585 (of 7,164 total)
You're welcome 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 16, 2012 at 12:55 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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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,
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 15, 2012 at 9:03 am
The build you're on should include the fix for the connect item I linked to. You may have run into a new bug. If you can reproduce it submit a...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 13, 2012 at 4:59 pm
darren.franklin (7/13/2012)
We use versioning software to add schema changes made in development to UAT...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 13, 2012 at 4:52 pm
Viewing 15 posts - 3,571 through 3,585 (of 7,164 total)