Browse by Tags
All Tags »
Tips-n-Tricks (RSS)
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...
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...
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...
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...
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...
Stuff I've been intending to post a meaningful post about, but haven't: If you have ever wondered what ildasm is all about, here's a great link. http://msdn.microsoft.com/msdnmag/issues/01/05/bugslayer/ Simple SQLCLR stored Proc deployment...
5 things I wish I had known or done prior to attempting to work with SOS.dll and windbg.exe: sos.dll needs to be in the path for windbg in order to load it you can .load %full path to sos.dll% instead of .load sos mscorwks or other statements SOS for...
something cool i've never heard of. quoted from http://blogs.msdn.com/dougste/ about a path value of \\?\C:\WEBSites\WWWMyApp\scripts: First of all, what is illegal about this path? Well, nothing, if you are a Unicode Win32 API. As you can read in...
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...
just saw this on http://blogs.msdn.com/queryoptteam/archive/2006/06/01/613516.aspx which i found on mark garner's awesome blog.
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...
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...
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...
There are a ton of articles about using command cancel vs close when you are using a datareader. The idea is that it will make things faster if you cancel the command rather than just closing it if you have an occasion to interrupt the execution. If you...
Dave got a request to allow someone to setup Visual Studio 6 so they could use Visual InterDev. I’m talking about recently, not years ago. For reasons I’m sure most people can guess, those packages are not allowed. It took me about 15 seconds on Google...