7 posts tagged as "sql-server"

Hello Gatsby

The first post on this site was written on July 27th, 2004. Wow, nearly 14 years ago. I believe it was written onScott Watermasysk's .Text platform, at least that is the first blogging platform I remember running for real. I eventually followed...

Restoring large SQL Server databases

When restoring a large SQL Server database (double-digit GBs) insure that the backup file is not on the same physical drive that your data file will reside. Having them on the same drive seems to slow down the restore process 10 fold. That number...

I need SQLPrompt

For the last year and a half I have been using a laptop as my primary development machine. A few weeks ago I got a new desktop and spent a few days installing most of the essentials. Since then I'll occasionally be reminded of some tool or...

Could not load type 'System.Web.Security.SqlProfileProvider'

Thankfully James Shaw wrote a post about this a bit back. His was the only result returned when searching Google for the error message. The answer: It's System.Web.Profile.SqlProfileProvider not System.Web.Security.SqlProfileProvider.

Removing duplicate rows from SQL Server table

I had a need to remove duplicate rows from a SQL Server table this morning and found this incredibly easy way to do so on the SQL Team site: select distinct * into #holding from dup_authors truncate table dup_authors insert dup_authors select...

Creating a PDF with SQL Server Stored Procs (and nothing else)

I found this beauty today via Mike Gunderloy's Daily Grind: http://ryanfarley.com/blog/archive/2004/10/25/1127.aspx Nice. I will have to play around with this a bit. Could prove to be useful.

I didn't know Query Analyzer could do that!?!

Mike Gunderloy's Query Analyzer Tips and Tricks Clearly, I have been seriously under utilizing (and probably underestimating) my friend, Query Analyzer. Mike Gunderloy is my hero.