Viewing 15 posts - 9,001 through 9,015 (of 9,399 total)
GilaMonster (9/2/2013)
SQLRNNR (9/2/2013)
Pins and needles seeing the strike-through on your MCM in the signature.I'll remove the strikeout in a week or two. Just making a point.
Like normal, Gail, you made...
September 3, 2013 at 11:03 am
Abu Dina (9/3/2013)
Ryan1 (9/3/2013)
wow guys thank you. I get it! muhahaha
What's funnier is that once you get through this book + plenty of practice, you'll start to see these...
September 3, 2013 at 10:59 am
Think of the subquery (O2) without the WHERE clause as a standalone query for a minute. Consider what it'll do by itself. It'll return the MAX(OrderID) from sales.orders....
September 3, 2013 at 10:22 am
I don't know how many developers you're going to have working on this database, but please know ahead of time that you're not going to be able to make everyone...
September 3, 2013 at 6:11 am
Jeff Moden (8/28/2013)
August 29, 2013 at 6:15 am
I find it interesting that lower case sorts ahead of upper case. In the ASCII character set I remember working with more than a few years ago, A is...
August 29, 2013 at 5:57 am
David Webb-CDS (8/23/2013)
I second Jeff's suggestion to store dates as dates.
I have to third Jeff's "store dates as dates" recommendation. I seem to spend a lot of time trying...
August 28, 2013 at 11:37 am
SQLRNNR (8/26/2013)
JAZZ Master (8/26/2013)
SQLRNNR (8/23/2013)
Daniel Bowlin (8/23/2013)
Ray K (8/23/2013)
SQLRNNR (8/22/2013)
opc.three (8/22/2013)
GanttHostess
Freihofers
Bakery
Donut run
Cinnamon Roll
flaming tire
Hot doughnuts
August 28, 2013 at 10:52 am
This is Ola Hallengren's maintenance solution. See http://ola.hallengren.com for details on it.
The URLs for the different parts of it are at in the comments the top of the file.
August 22, 2013 at 11:19 am
This was a nice one for me because we don't have 2012 (sigh) and it got me to research a 2012-only function. Thanks.
August 22, 2013 at 7:14 am
crookj (8/20/2013)
Ed Wagner (8/20/2013)
bcsims 90437 (8/19/2013)
Revenant (8/19/2013)
crookj (8/19/2013)
opc.three (8/16/2013)
Jeff Moden (8/16/2013)
SQLRNNR (8/16/2013)
Jeff Moden (8/16/2013)
Retrofit (wishful thinking).partition
Spot-on
Spotfire
Spitfire
Hurricane
Tsunami
Storm
Wolverine
University of Michigan
August 20, 2013 at 1:44 pm
GilaMonster (8/19/2013)
Have you considered backing up to disk and moving the backup to tape later?
During a backup, your disk I/O is going to be high. You want to minimize...
August 20, 2013 at 6:18 am
Koen Verbeeck (8/19/2013)
GilaMonster (8/19/2013)
Ed Wagner (8/19/2013)
August 20, 2013 at 6:06 am
bcsims 90437 (8/19/2013)
Revenant (8/19/2013)
crookj (8/19/2013)
opc.three (8/16/2013)
Jeff Moden (8/16/2013)
SQLRNNR (8/16/2013)
Jeff Moden (8/16/2013)
Retrofit (wishful thinking).partition
Spot-on
Spotfire
Spitfire
Hurricane
Tsunami
Storm
August 20, 2013 at 5:57 am
I've never used it, but it looks like it might be something we could use. Thanks for the introduction to a product I know nothing about.
August 20, 2013 at 5:56 am
Viewing 15 posts - 9,001 through 9,015 (of 9,399 total)