Browse by Tags

'net' command (net user, net localgroup, etc)

it's depressing to me how many people that i run into today that have an excrutiatingly limited knowledge about the command line in windows, and yet they are considered experts on the platform. that aside, i figured i would share a couple of very simple uses. something people ask a lot is what domain...

Posted to roy ashbrook (Weblog) by royashbrook on 07-29-2008
Why "SET NOCOUNT ON" Sucks

As I mentioned in a previous post , David Hayden sat in the front row and gave me an especially hard time about ‘set nocount on’ as a tip. I don’t remember the exact words, so I’m going to have to roughly paraphrase. His complaint was that some data access layers or object relational mapping tools or...

Posted to roy ashbrook (Weblog) by royashbrook on 07-17-2007
Tampa Code Camp Slides

You can download the slides I used for my "SQL Tips n' Tricks for Developers" talk at the Tampa Code Camp (7/14/2007) from the following location: http://drowningintechnicaldebt.com/files/folders/royashbrook/entry403.aspx Here's the session description: This session is designed to bridge...

Posted to roy ashbrook (Weblog) by royashbrook on 07-16-2007
how do i alter fill factor on all tables in a database or for a whole server

Recently we had an issue at work where nightly MS SQL Server DB index defrags were taking a long time. Upon looking at the logs it appeared that almost all of the tables were fragmented quite often. It didn't take long to ask if anyone ever modified the fill factor from the default of 0. Nope. If...

Posted to roy ashbrook (Weblog) by royashbrook on 07-10-2007
use CommandBehavior.CloseConnection even with usings

Recently I put together a SQL talk for developers and gave it at our local JAXDUG meeting. It went over well and one of the items I covered was utilizing CommandBehavior.CloseConnection with the command being used. While the implicit finally created by the using connection below will close the connection...

Posted to roy ashbrook (Weblog) by royashbrook on 07-10-2007
SQL SSIS Best Practices

I’m wanting to compile a basic best practices list for SSIS. I don’t really need to get into tons of details for my list, I really just want to say have the big 10 DO and the big 10 DO NOT. Here are my sources for research so far. http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx http...

Posted to roy ashbrook (Weblog) by royashbrook on 05-04-2007
auto index suggestion for sql2005

just saw this on http://blogs.msdn.com/queryoptteam/archive/2006/06/01/613516.aspx which i found on mark garner's awesome blog.

Posted to roy ashbrook (Weblog) by royashbrook on 05-04-2007
space used in tempdb. or any db.

so not too long ago, we had a need to monitor the space used by our tempdb. one of the other dbas had sent out a script on how to do it that i imagine he found somewhere. when i finally got around to processing that email i forwarded him the sp_spaceused command. very easy built in proc that will give...

Posted to roy ashbrook (Weblog) by royashbrook on 05-04-2007
SQL native stack joins on text files

snipped from here . Openrowset now allows the BULK clause to be specified which accepts a filename and format specification. An OLE-DB driver for flat-files or XML would also do the job but this is a nice work-around for the native stack. The only difficulty is getting your head around the format for...

Posted to roy ashbrook (Weblog) by royashbrook on 05-04-2007
SSIS, Bulk Loading, 1GB in an hour??

OK, so several times recently I have heard about SSIS being able to load 1TB in an hour. These comments had no reference other than something they read once, which is cool because we all probably do that stuff all the time. So, I have current need to research and define some SSIS and General Integration...

Posted to roy ashbrook (Weblog) by royashbrook on 05-04-2007

Page 1 of 2 (11 items) 1 2 Next >