Sioban Krzywicki (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

Eirikur Eiriksson (4/3/2015)

---

Are you grumpy because you are working on the Good Friday or was it the last night "preparation"...

Depending on the usage, distribution and cardinality, there are few options to speed this up.

😎

One would be adding a calculated column and then index the column, this has little...

Koen Verbeeck (4/3/2015)

---

Eirikur Eiriksson (4/3/2015)

---

Are you grumpy because you are working on the Good Friday or was it the last night "preparation" for it...

Are you grumpy because you are working on the Good Friday or was it the last night "preparation" for it that make you grumpy?...

sqlmaverick (4/2/2015)

---

Hi all,

I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but...

I use this Microsoft SQL Server 2012 Database Security Technical Implementation Guide[/url]

😎

Apart from the...

jasona.work (4/3/2015)

---

I started having this issue yesterday, after applying a change to bring my server(s) in compliance with the DISA STIGs. One of the requirements of the STIG is...

For starters can you post the DDL (create table) for the tables and some consumable sample data in the form of an insert statement? This will increase your chances of...

Looks like the only thing missing is actually to execute the dynamic sql

😎

EXEC (@sql);

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

DECLARE @strname varchar(50) = '3 April 15 abcd Oh rrrrrrrAAAAdd HJHJG';

DECLARE @SAMPLE_DATA TABLE

(

SD_ID INT NOT NULL

,SD_TEXT...

Quick answer, it depends.

😎

Start by reading through these articles

...

Quick point, the temporary table resides in the tempdb, change the db part of the object_id function's parameter to point to it.

😎

/* Any User Database */

USE Test;

GO

/* The temporary table...

Quick thought, use READPAST rather than dirty read

😎

voyage

shooting