Jeremiah Peschka

SQL Server
GUID Ordering in SQL Server – Look, I know what I’ve said about GUIDs. Nobody wants them around, except developers. The point is that sometimes GUIDs are a necessity. We all might as well learn how to deal with them. Martin Bell does a great job of talking about the various ways of generating [...]

Lady GaGa has nothing on my ability to do zany math with SQL Server

Big pile o’ link love this week. Honestly, I didn’t include a ton of GREAT links from Brent Ozar because people would start to think that Brent Ozar pays me to link to his site and say Brent Ozar a lot. He doesn’t, but if you click on the links to Brent Ozar maybe he’ll [...]

Typically, moving data isn’t that big of a deal. You can either fire up SSMS and write a quick script to copy data from one server to another. Or, if you need to move data from production into development, you can just do a back up and restore.
“Typically” is the key word in the previous [...]

Thanks to Ted Krueger (onpnt if you’re on twitter or use lessthandot.com), I now know how to display a BIGINT in RAISERROR. You just used %I64d. It’s documented in BOL as a sidebar note, but you still have to wade through the RAISERROR documentation.
So, our code would look like this:

DECLARE @i AS BIGINT;
SET @i = [...]