we do SOX once a year

we get a document and have to provide screen shots and other proof. the auditors have a checklist they go by. then they ask for...

official MS is DPS. in alphabetical order. distributor, publisher, sub

but we have sql 2000 publishers with 2005 subs. i think you just have to create the publication with SSMS

maintenance script

still a bug or two in there since i'm making some changes. base code is from BOL and i've made changes over the years

USE [RA]

GO

/****** Object: StoredProcedure [dbo].[usp_alter_index_online]...

script to gather index frag data and dump to a database

-- Run system view to gather fragmentation data and insert into table

INSERT into index_stats.dbo.physical_stats ( database_id,

object_id,

index_id,

partition_number,

index_type_desc,

alloc_unit_type_desc,

index_depth,

index_level,

avg_fragmentation_in_percent,

fragment_count,

avg_fragment_size_in_pages,

page_count,

avg_page_space_used_in_percent,

record_count,

ghost_record_count,

version_ghost_record_count,

min_record_size_in_bytes,

max_record_size_in_bytes,

avg_record_size_in_bytes,

forwarded_record_count,

server_name,

date,

database_name

)

select database_id,

object_id,

index_id,

partition_number,

index_type_desc,

alloc_unit_type_desc,

index_depth,

index_level,

avg_fragmentation_in_percent,

fragment_count,

avg_fragment_size_in_pages,

page_count,

avg_page_space_used_in_percent,

record_count,

ghost_record_count,

version_ghost_record_count,

min_record_size_in_bytes,

max_record_size_in_bytes,

avg_record_size_in_bytes,

forwarded_record_count,

server_name...

i always prefer CTE's and table variables. i've had a few issues with temp tables where the query ran but for some reason the temp table doesn't get deleted and...

Stefan Krzywicki (8/2/2010)

---

alen teplitsky (8/2/2010)

---

wish i just had a tally table

bought my wife an iPhone 4 just now and needed to know which days were week 30 of 2010 since...

wish i just had a tally table

bought my wife an iPhone 4 just now and needed to know which days were week 30 of 2010 since that when her phone...

thx

i've read tally table articles here for the last few years and never thought i had a use for them. last 6 months i've been building a performance data warehouse...

too bad i have to unlazy myself and add this to the calendar manually so i don't forget

a year or so ago we decided to implement logon triggers. tested in QA first. good thing because we locked out the server for 3 hours or so until i...

no auto shrink, very rarely do we do manual shrinks and no GUID clustered indexes or PK's

and i'm seeing it on indexes and tables with tens of thousands of pages

one...

what's your OS?

on x86 if you have more than 4GB of RAM than things like execution plans can be cached above the first 4GB but not the data access. on an old...

steve block (7/26/2010)

---

That is the beauty of using server side traces, you don't use profiler. Instead, you execute an sp_trace_create statement to create a trace to a trace file,...

if there is we haven't reached it yet. we have a database pushing 2TB running on SQL 2005 Standard x64