Browsing the archives for the SysAdmin category

Size of Filegroups and Files

In recent posts I looked at queries that show us data at the instance, the database, backups and now we will look at filegroups and the individual physical files. Too many times disk space is not an issue, it is THE issue.  This query will show several key attributes of our database at the file […]

SQL Server Backup Compression Default

In SQL Server 2008 Microsoft added the long overdue backup compression feature.  You may have noticed in the backup dialog box the pull down menu to use the DEFAULT SERVER SETTING for compression. To determine what the DEFAULT value actually is: Out of the box, SQL Server 2008 backup compression is turned OFF.  To avoid […]

0 Comments

How to Drop a TempDB Database File

Now The SQL Server tempDB is arguably the most important database in any installed instance.  A poorly configured tempdb will trump all the best efforts for design of good OLTP or datawarehouse systems. The standard recommendation is to have one tempdb database file for each CPU.  It’s also generally recognized that this rule of thumb […]

0 Comments

DBA Query: Instance Information

As part of my weekly routine I like to take a holistic view of the production servers I am responsible for.  After backups and maintenance plans, the next most important role of the DBA is to keep an eye on the overall health of the production databases. I have several queries that I use to […]

0 Comments

Monitor Transaction Isolation Levels

As part of a performance improvement effort we decided to make sure our enterprise reporting tools are operating under the READ UNCOMMITTED transaction isolation level (ie., allow dirty reads).  While our reporting application experts were certain the tools were at the desired isolation level we decided to monitor the actual transactions just to be sure. […]

Maintaining Accurate SQL Server Statistics in Small Maintenance Windows

The single most important component of the SQL Server product is the query optimizer. The SQL Server storage engine utilizes a cost-based optimizer to determine optimal query plans. The job of the optimizer is to determine an optimal plan that will result in exceptional performance. Note: An “optimal plan” is not necessarily the same as […]

Move Tables to New Filegroup

About a year ago I showed how to move data in a table to a new partition by modifying the clustered index.  Since the clustered index contains the data for the table, moving the clustered index is equivalent to moving the table. This post is a simpler example of using the clustered index to move […]

0 Comments

Set up Dedicated Administrator Connection (DAC) before you need it!

When I was in elementary school we often had planned “fire drills”.  We would be told of the impending alarms, the alarms would go off, and we’d all exit the school in an orderly fashion using the prescribed path and exits. Fast forward a hundred years and I’ve discovered why fire drills are important…  So […]

Upgrading SQL Server 2008 Trial Version to Developer Edition

After six months of using SQL Server 2008 Trial, the party is finally over; my free trial has expired.  Unlike most trial software applications Microsoft does not present the user with a dialog box indicating that there are only X number of days remaining with the trial version.  The SQL Server service will just shutdown […]

Charlotte SQL Server Users Group, Guest Speaker Kevin Kline

Just in time for the Holidays…  Kevin Kline has come to town. Kevin’s topic at the Charlotte SQL Server Users Group weighed the pros and cons of SQL Server virtualization.  In this post I will note some of the many points that I learned. Before I dive into the technology details I would like to […]

Using Database Snapshots To Test Loads

When testing data warehouse ETL routines it’s often necessary to be able to reload the same data several times before you get the code dialed in and ready for production work.  One way to be able to do this is to simply TRUNCATE the target table, assuming there are no foreign keys on it.  If […]

popular blog editor sites uk best speech writer websites usa rhetorical analysis essay editor websites au professional phd dissertation hypothesis topics esl dissertation methodology writing website usa pay for anthropology blog post cheap dissertation chapter ghostwriter service online personal essay editor site gb critical writer service uk professional dissertation conclusion ghostwriters websites online write me trigonometry speech esl definition essay ghostwriters for hire usa the goldfish matisse write my environmental studies content custom problem solving writer services for phd the virtue theory popular rhetorical analysis essay editing for hire for college top mba article advice professional critical analysis essay editor site gb esl proofreading website uk type my music dissertation chapter top definition essay proofreading service for phd top scholarship essay on hillary top admission essay writers services for school pay to do composition essay best descriptive essay writers sites au custom custom essay editor websites uk top creative essay writers services gb cheap university essay writer service ca custom dissertation writer sites for mba help writing cheap phd essay on lincoln best essays editing service usa top creative writing ghostwriters sites uk cheap content ghostwriter services for masters custom bibliography ghostwriting service for phd pay for film studies course work cheap bibliography ghostwriting sites for university custom cover letter ghostwriting site for mba professional thesis statement writing sites for school top dissertation results writing for hire popular admission paper writers for hire for school esl essay ghostwriter site for masters persuasive essay ghostwriting service usa do my top university essay on hacking professional phd personal essay example custom business plan writer website uk top bibliography editor website for university professional course work proofreading services us professional research proposal proofreading sites for college popular dissertation methodology writer site us best article review proofreading for hire usa esl letter proofreading for hire online help writing persuasive essay on hillary pay for my best academic essay on lincoln custom college cv examples write me statistics bibliography cool hand luke symbolism best paper editing websites for university esl reflective essay writers for hire online critical writers service gb dissertation writers service uk analysis essay ghostwriting for hire gb cheap critical analysis essay editing websites usa order history dissertation methodology lysistrata shmoop best scholarship essay ghostwriters websites write algebra blog popular cv ghostwriting for hire for mba custom paper editing website for school cheap report writers for hire uk teenage suicide essay best personal statement writers sites uk help with my custom creative writing popular dissertation introduction ghostwriters services ca top thesis ghostwriters services ca esl thesis proposal editor site for university definition essay on happiness esl curriculum vitae ghostwriter sites for school custom critical essay ghostwriting website ca top paper writer service top dissertation abstract writer sites for mba professional analysis essay writers service for university popular biography ghostwriters services us top speech ghostwriter services for masters best problem solving ghostwriter services us buy admission essay on usa custom article ghostwriting site usa esl dissertation hypothesis ghostwriters service us cheap critical analysis essay proofreading website for masters help with health thesis statement help me write music course work top thesis ghostwriters service online best application letter writer websites for mba descriptive writer sites usa do my top critical analysis essay online esl school essay ghostwriters service for college presentation ghostwriters for hire ca help me write custom case study online best academic essay editor site for masters top research proposal editing service usa pay to get dissertation chapter online pay for my esl argumentative essay on donald trump adolf hitler essay is frankenstein the monster nursing essay editing websites a good argumentative essay professional presentation ghostwriting service gb popular expository essay editor for hire for school cheap homework ghostwriting websites for university law enforcement essay topics professional course work ghostwriters service for phd popular dissertation abstract writers websites for masters esl paper writer service us esl research paper writers sites gb popular dissertation chapter writers site us professional case study writing service for university write my custom personal essay on lincoln pay for finance curriculum vitae do my ancient civilizations essays best case study ghostwriting website for mba best school essay editing website ca popular movie review proofreading services for mba top annotated bibliography editor sites ca professional personal statement proofreading sites for university custom rhetorical analysis essay writers services for mba esl business plan writer service ca pay to write art & architecture literature review best papers ghostwriting services uk oppressed in spanish best case study ghostwriters sites professional dissertation chapter writer for hire for phd professional home work writer sites online professional personal statement writer websites help with popular creative essay on hillary clinton help with my geology admission paper professional dissertation editing services gb top college essay writing for hire esl personal essay writer websites us pay for astronomy cover letter popular phd essay ghostwriters services uk cheap mba thesis proposal advice top homework writing services gb popular biography proofreading for hire us professional dissertation hypothesis ghostwriter website for mba custom admission essay proofreading for hire for university order professional college essay esl dissertation chapter proofreading websites gb best essay on technology the road not taken analysis essay popular admission essay writer websites for masters best curriculum vitae ghostwriter website ca the role of women in the french revolution custom critical essay writing service for school top dissertation abstract ghostwriting websites ca essay advice online creative editing services usa popular thesis statement ghostwriting service for masters forgiving my father lucille clifton professional personal statement writing service for school top dissertation methodology writer websites uk popular literature review proofreading site usa custom university curriculum vitae ideas dissertation proposal writer services us essay describe a person best admission essay writers site for school best home work ghostwriter website best dissertation abstract ghostwriter for hire online cheap college dissertation abstract assistance top scholarship essay writer websites for school top content writing website for college top dissertation abstract editor website us custom phd masters essay assistance cheap article ghostwriter service for school esl definition essay editor services for school top analysis essay editor websites uk pay for my logic essays popular resume ghostwriters websites usa cheap descriptive essay writer website ca custom dissertation hypothesis writers for hire for phd professional application letter ghostwriting website usa top admission essay writer service au top expository essay proofreading services for mba cheap report proofreading sites gb write tourism curriculum vitae pay to do professional reflective essay on trump professional dissertation editing for hire gb cheap literature review proofreading services ca buy academic essay on donald trump esl bibliography writers site uk cheap resume ghostwriting service for phd mills harm principle thesis ghostwriting service benefits of cloning a modest proposal illustrations professional presentation writing website uk cheap dissertation methodology ghostwriters website uk custom thesis editor for hire for college top dissertation chapter writing sites au top personal essay editor site for masters custom mba papers examples cheap annotated bibliography writers websites for masters best annotated bibliography editor for hire ca help me write education creative writing best dissertation results ghostwriting websites gb cheap university essay writing service ca esl essay writer services for masters scholarship editing service gb custom dissertation hypothesis editor site for mba popular business plan editing websites gb popular essay editor sites for masters custom essays writer website us resume ghostwriting for hire uk type my film studies case study professional critical analysis essay on presidential elections best admission essay ghostwriting service au type my custom critical thinking online custom homework writers site for college best best essay editor website for college tourism essay ghostwriters website professional papers ghostwriters website uk esl college school essay topics best masters cover letter samples popular biography ghostwriting websites gb popular case study ghostwriting websites for masters custom best essay ghostwriter service for school best best essay editor for hire for college popular essay ghostwriter service uk popular dissertation proposal editing services popular resume ghostwriting sites for mba top article writers sites for phd help with my theater studies dissertation methodology professional phd college essay example write my cheap best essay online cheap book review ghostwriter sites for phd type my custom essay on trump top book review writing site custom personal essay proofreading websites usa popular dissertation methodology writing services admission paper editor for hire us best admission paper ghostwriter website for university cheap dissertation results ghostwriter sites gb professional problem solving ghostwriters sites uk cheap course work writer service online best phd essay writing services ca best literature review editing for hire for university best critical thinking ghostwriters websites for phd write my life science dissertation hypothesis should sex education be taught in schools essay popular critical thinking writer services us masters editor site uk philosophy essay assistance admission paper writing service gb annotated bibliography editor site usa top custom essay writers services for mba top argumentative essay writing site for masters professional admission paper ghostwriters site us pay to do custom university essay on founding fathers type my religious studies dissertation introduction help writing management biography popular mba analysis essay ideas do my education thesis proposal professional dissertation conclusion proofreading service for masters best assignment proofreading website gb top argumentative essay proofreading site for mba popular dissertation proposal writer websites au cheap university thesis ideas best phd critical essay assistance all we have to fear is fear itself esl creative writing editor site usa popular papers writers service for college top custom essay proofreading site for masters nursing essay writing website top dissertation introduction writer services for masters professional masters essay proofreading service for school volcano essay top cover letter ghostwriters services for phd write me popular school essay on lincoln help with algebra business plan jones blair paint professional report editing services ca pay for art & architecture application letter best dissertation writer service us best mba presentation ideas goodfellas synopsis cheap college custom essay topics help with popular rhetorical analysis essay on lincoln popular blog proofreading websites us fahrenheit 451 conformity vs individuality best blog post ghostwriting site usa best creative essay writer sites professional best essay proofreading site for phd custom dissertation chapter writers service for college cheap blog writer website uk article review editing services cheap biography writer for hire for mba top papers proofreading website for mba help writing biology dissertation introduction type my esl analysis essay on presidential elections cheap article review writer service for school custom descriptive essay ghostwriting site uk esl creative essay writer sites for phd esl school essay proofreading website for university help me write best essay on hillary clinton dissertation abstract writing for hire gb esl thesis statement writers site for college custom essays writer service for masters professional curriculum vitae writing sites for masters popular academic essay ghostwriters websites uk popular academic essay ghostwriter websites gb report editing for hire gb cheap reflective essay ghostwriter site for university custom thesis proofreading for hire for masters macbeth violence quotes symbolism in the metamorphosis esl report proofreading service us best blog post editor website for college esl application letter writer website ca write anthropology cover letter research paper ghostwriting services au top article writers site for masters popular blog post ghostwriter service for phd top creative essay ghostwriter website for masters custom persuasive essay ghostwriter sites au cheap paper writing site ca top article writers for hire gb pay for custom college essay type my esl descriptive essay on founding fathers popular essays ghostwriters website us order finance critical thinking problem solving ghostwriters website custom admission essay ghostwriting for hire gb cheap persuasive essay ghostwriters website us order medicine literature review what is a family essay professional descriptive essay editor service for masters esl critical essay writers for hire esl essays writer website uk cheap argumentative essay proofreading service for school popular movie review ghostwriters service for mba professional cover letter ghostwriter services online custom thesis editor services us health proofreading services professional thesis proposal editing for hire us write me top critical essay on trump write my popular custom essay on hacking custom paper ghostwriter service ca custom argumentative essay editing site for phd best papers ghostwriter site for masters admission paper proofreading site au admission paper ghostwriting website ca top creative writing proofreading services for college creative writing ghostwriting for hire au professional masters essay ghostwriter service for masters professional college essay ghostwriting website us professional letter proofreading website usa top cv proofreading site for university best thesis statement writer services gb best best essay writers website usa cheap phd case study topic esl dissertation chapter ghostwriters service for mba cheap best essay ghostwriting sites usa write geometry home work cheap writers site au yeast respiration lab report esl presentation ghostwriting service enlightenment essays cheap case study ghostwriter websites for masters color symbols in the great gatsby custom dissertation abstract ghostwriter services uk pay to do best university essay online cheap dissertation hypothesis ghostwriter site uk best definition essay editing site usa esl academic essay editor services us do my professional academic essay on hillary custom mba thesis proposal examples professional admission paper ghostwriting website us professional papers ghostwriters site ca order esl cheap essay on presidential elections write math blog post write my finance home work top dissertation abstract ghostwriter site for school esl reflective essay writer services uk cheap university essay editor site gb critical analysis proofreading website online cheap dissertation conclusion editing website popular research proposal writer site for university top admission paper writer site online custom dissertation introduction editor websites for college through the tunnel analysis professional thesis proposal writing service uk esl content ghostwriter site for phd esl content writing websites ca pay for my zoology thesis esl dissertation conclusion editor for hire ca cheap critical analysis essay proofreading site us professional critical thinking writers services ca best school paper example cheap persuasive essay writers website for college best problem solving writer websites for school the tortilla curtain themes custom phd essay on usa write me world affairs creative writing school essay writers site us esl research proposal ghostwriting service for phd custom phd cv help help with my chemistry movie review what is the theme of the short story the lottery professional masters essay ghostwriting for hire for university cheap scholarship essay writers site for university argumentative essay editor for hire online best thesis ghostwriting for hire for masters esl dissertation results editor site for college custom application letter writer website ca equal men and women admission essay writers websites gb phd essay writer service online custom persuasive essay ghostwriter services au bentham vs kant top article writer services for masters custom critical analysis essay writers site usa pay for top cover letter university essay editing services online dissertation abstract ghostwriter for hire us college proofreading sites usa physics of bridges top research paper ghostwriter for hire au cheap descriptive essay ghostwriter site uk cheap scholarship essay proofreading sites au best descriptive essay editing services ca top dissertation abstract editing for hire uk best essay ghostwriter for hire usa custom argumentative essay writing websites for school investments essay writing services top home work ghostwriters service for masters esl term paper writing services au write my top definition essay on hillary professional critical thinking writer for hire online mackiavelli green stripe matisse gothic elements in frankenstein pay to get professional cover letter online cheap course work ghostwriters website for school popular expository essay writer website for school do my cheap academic essay on trump pay to get article review esl university essay editor sites ca custom book review ghostwriters websites pay for physics creative writing professional persuasive essay editing services online top paper ghostwriter site ca dissertation conclusion writer service us 3 causes of the civil war essay popular reflective essay ghostwriter sites uk professional course work writers service for mba esl critical thinking ghostwriter website cheap definition essay writing websites gb what are your goals and aspirations top article review ghostwriters website online best article review writers services usa analysis of because i couldnt stop for death pay for my engineering article esl content editing service for university popular article writers site online top papers writing service poem wild geese science is bad popular custom essay ghostwriters service au summary of because i could not stop for death professional application letter proofreading services uk best dissertation proofreading site for college top homework writing services au cheap resume ghostwriter site gb best thesis proposal editing websites us pay to write top dissertation conclusion custom descriptive essay writing websites for college professional argumentative essay editor sites usa best college rhetorical analysis essay assistance blog writing website online professional speech editing websites online popular dissertation chapter editing for hire custom rhetorical analysis essay ghostwriters sites uk esl blog editing sites online cheap rhetorical analysis essay editor for hire online esl problem solving writing services au cheap dissertation introduction ghostwriting services online best critical essay proofreading sites uk pay to do professional analysis essay on civil war cheap ghostwriter service for phd esl bibliography writers site gb professional resume writing services gb professional resume proofreading websites online top cover letter writing service write my social studies letter best school research paper personal essay editing service uk popular essay writing sites for mba professional report ghostwriting service uk esl book review writers websites ca admission essay writer sites ca best expository essay ghostwriters services usa