I'm not quite sure what you mean by this, Luis. When I think of snippets, I'm thinking of code I reuse over and over, but generally I just save the...

Ed Wagner (8/31/2015)

---

Sean Lange (8/31/2015)

---

Grant Fritchey (8/31/2015)

---

For the upgrade to 10, I think I'd suggest holding off a while. I'm seeing occasional errors: faulty_hardware_corrupted_page. From the Microsoft forums, quite a...

Ed Wagner (8/31/2015)

---

TomThomson (8/30/2015)

---

Just upgraded my toy to Windows 10 (MS had work to do to make it possible on tis hardware, so couldn't do it earlier).

It took a very...

I had a fun afternoon / morning of ol' fashioned data entry. Joyous!

Oh, yeah. I use that one quite often. But I don't think that's what Grant is looking...

Doing experiments this morning. I've got to update a table to fix data problems introduced by a bad file. So I'm in test and realize that Things Are Getting Complicated....

GilaMonster (8/25/2015)

---

djj (8/24/2015)

---

GilaMonster (8/24/2015)

---

I think it's in anticipation of my Star Wars RPG tonight. The puny resistance movement will be crushed under the might of the Imperial Army. The Emperor...

Shawn, that is AWESOME. Thank you for checking that. I'll pass this along to our local team.

It's as if a thousand bits cried out at once,...

Shawn Melton (8/23/2015)

---

IIRC if you want to restore a database with a differential you would add the full AND differential files into the device window of the GUI. It has...

I will add some others later, but here's one I frequently use for our non-prod environments.

SELECT TOP 10 *

FROM msdb.dbo.restorehistory

WHERE destination_database_name = 'MyDatabase'

ORDER BY restore_date DESC;

--check the last time a...

Steve Jones - SSC Editor (8/21/2015)

---

I had someone ask recently about seeing more dev articles, especially T-SQL based ones. Anyone up for doing some one-pagers that solve some of the...

Phil Parkin (8/21/2015)

---

Ah yes, tried to take a sneaky shortcut. Needs to be fixed:

and sjh.run_date >= (year(getdate() - 1) * 10000 + month(getdate() - 1) * 100 + day(getdate() -...

Brandie Tarvin (8/20/2015)

---

I don't know about 2012, but in 2008 something would be wrong if the mirrored dbs aren't showing in sys.databases. I have 4 mirrored DBs in 2008 that...

Sean Lange (8/20/2015)

---

Luis Cazares (8/20/2015)

---

Lynn Pettis (8/19/2015)

---

Silver spoon, silver spoon, silver spoon, when are you going to admit you are in over your head and really need to find a...