Browse by Tags
All Tags »
SQL Server (
RSS)
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 is pulled...
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 utility that...
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. Share this...
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 * from #holding...