mwpowellhtx (3/17/2015)

---

It is an interesting exercise, but doesn't really accomplish anything anyone would encounter in the real world. BREAK is an interesting SQL keyword, did not know that. Also beware...

I worked at a company where all the identity columns were decimal(18,0), and I'd already made small tables in other circumstances that were tinyint, so easy one for me. if...

By having the structure you're asking for, along with a sequence, doesn't that make it no longer random?

I've done something similar on a smaller scale to get every 3...

As I recall part of the problem is it depends where in the file the longer records are. My recollection is that the first few records (I don't know how...

Richard Warr (10/31/2014)

---

Sadly my eyesight isn't what it was and I misread "Shirts" as a similar word without an "r" in it.

I quickly reached the conclusion that Steve would have...

TomThomson (6/18/2014)

---

paul.goldstraw (6/18/2014)

---

I made the same logical leap as Koen, most of Andy's questions include hints within the question to help rule out certain possibilities,

- On site = No...

I made the same logical leap as Koen, most of Andy's questions include hints within the question to help rule out certain possibilities,

- On site = No Azure

- SQL...

He must mean July as SQLBits is July 17th, either that or...

Hany Helmy (5/17/2014)

---

paul.goldstraw (5/16/2014)

I had a similar problem with 2012 where using CTRL+R didn't toggle the results window. I followed the advice on this page. Perhaps you're affected in the...

bgdjwoods (5/16/2014)

---

I tried this several times and even for the question the other day that referred to this, no go.. this does not work. I get the error that...

Richard Warr (5/16/2014)

---

paul.goldstraw (5/16/2014)

---

Maybe he's running SQL Server 2012 QOTD...

Also Ctrl+Shft+D does do something, it refreshes the cache in SQL Prompt, which is funny considering this is a Red-Gate site. Opportunity for a product plug there 🙂

Maybe he's running SQL Server 2012 QOTD Edition? 😉

PHYData DBA (4/29/2014)

---

paul.goldstraw (4/29/2014)

---

I think we're just reading the question differently. I read 'ALL queries' in the context of the database we don't want to use the new optimiser. If...

PHYData DBA (4/29/2014)

---

You are right. It said Alter ALL queries to use this trace flag. Not just the queries that use the database they want to disable CE for....