I've heard it said by someone here that "You don't need a backup strategy...you need a restore strategy". I don't remember who said it, but it stuck with me...

Well, at least that makes sense. 🙂

The dbo schema first, then default. Thank you, Lowell. I just learned something.

Every user in a database has a default schema whether they like it or not. This is at the database user level, not the login level. If you...

I don't know if you were able to resolve this yet, but I think...

I've never used the filestream so I won't comment on it, but I have stored images (and lots of other file types, such as AutoCad) in Oracle and SQL Server...

anthony.green (3/8/2013)

---

I would seriously look at your sever specs as well, 1 drive for both your MDF and LDFs, also are your backups going to the same drive?

Get separate disks...

It depends on what data types you're using in Oracle versus what you're going to use in SQL Server. Each platform stores things a little differently, so the usual...

I've done the backup...copy...restore scenario quite a bit and it works very well. If you need to move your data files to other drives on the new server, there...

If I'm not mistaken, SSMS shows NULL values with a yellow background to differentiate them from the rest of the result set. I personally think it's a good approach....

I believe online rebuild is not an available in Standard Edition.

Without a maintenance window or Enterprise Edition, rebuilding isn't going be an option for you.

So you're left with reorganizing.

A few years ago, I left a secure position where I was just shy of 15 years. There's definitely some trepidation involved in such a move. I now...

Thanks, Sean. Good article. You know, I'm consistently impressed by just how many different uses there are for the tally table. So simple in design, yet the...

Lynn Pettis (2/27/2013)

---

Ed Wagner (2/27/2013)

---

I like Lynne's approach of splitting it inline and keeping it to a single query instead of using temp tables. Also, her function will be...

Good point. After the function is set up initially, it's also more straightforward to use.