This morning, I was trying to restore a database from a SQL 2005 backup to a new server. The restore involved a full backup and a differential. I restored the full backup with NORECOVERY via SSMS, but when I tried to restore the differential, also via SSMS, I got this error: Okaaay. I was a […]
This has been a somewhat scattered week. As I alluded to earlier, my mind has been pulled in all different directions after a week of training and listening to presentations. I really have to work on writing my ideas down somewhere, as I have them, and getting them out of my head until I’m ready […]
The problem with user conferences is that they usually leave me with a slight case of ADD the following Monday. So much stuff, I have to try it all NOW!!! SQL Saturday #75 this past weekend in Columbus was no exception. There were some really good presentations and for a couple time slots it was […]
Well, to say I “learned” about XML and CLR is a bit disingenuous. More accurately, the instructor went over XML and CLR. But to be honest, I know so little about either subject that it was a bit like listening to Charlie Brown’s teacher. But anyway, we covered it and it gave me some ideas […]
Since SQL Server 2000, you’ve been able to create variables of type TABLE, but you needed to define that table structure when (and each time) you declared the variable. You also couldn’t pass these table variables into a stored procedure. SQL Server 2008 introduced the user-defined TABLE datatype. Now you can create and store custom-made […]
