ChrisM@Work (1/22/2016)

---

Ed Wagner (1/22/2016)

---

Greg Edwards-268690 (1/21/2016)

---

Eirikur Eiriksson (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

Steve Jones - SSC Editor (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

It seems he has an elephant on the menu, and a 6 quart pot...

Ed Wagner (1/23/2016)

---

jasona.work (1/22/2016)

---

So I just had an amusing moment...

I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this...

Ed Wagner (1/23/2016)

---

Piling on, I have to agree with the majority opinion here - this is a bad idea. If you're going to reuse IDs that are primary keys,...

Jeff Moden (1/22/2016)

---

Eirikur Eiriksson (1/22/2016)

---

The quick suggestion towards a solution posted earlier was just that, less than two minutes of coding to demonstrate a method for identifying groups in sequences....

Strongly advice you not to use the format function as it performs very badly.

😎

You have 15 minutes passed midnight in your query, if you need...

jcachado (1/23/2016)

---

Hi, i need help please,

Why this not work:

SELECT change_dtim,create_dtim,ckpt_id,Format([change_dtim]-[create_dtim],'hh:nn:ss') as tempo FROM Back_ickpt_plz where tempo > '00:15:00'

if i remove the where tempo > '00:15:00' , run .

What is my...

Luis and Jack, you are both right in the terms of suppressing the problem, preventing it is in my mind a better approach.

😎

I'll have a look, can you get couple of data samples to work with, makes things easier as otherwise I would have to start guessing.

😎

I've done systems that to high...

Brandie Tarvin (1/22/2016)

---

Eirikur Eiriksson (1/22/2016)

---

Quick suggestion, change the #dbsize create script

😎

CREATE TABLE #dbsize

(

Dbname SYSNAME ...

Quick suggestion, change the #dbsize create script

😎

CREATE TABLE #dbsize

(

Dbname SYSNAME ...

er.mayankshukla (1/22/2016)

---

Hi All,

In one of the application, we have to restrict the developers from creating a table with unicode columns.

I was thinking if I can use Policy based management for...

Eric M Russell (1/21/2016)

---

Eirikur Eiriksson (1/20/2016)

---

...

...

Quite impressive, 28 operators in the execution plan, parallel execution, four full table scans and I'm now putting out the fire ignited by the CPU...

The quick suggestion towards a solution posted earlier was just that, less than two minutes of coding to demonstrate a method for identifying groups in sequences. Now with further 5...

Quick suggestion, a different and more efficient way of doing this

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_SIZE INT = 1000;

;WITH T(N) AS (SELECT N FROM ( VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS...