Quick thought, the first (union) query will use two index seek operators (if the correct indices are in place) while the latter does a single scan. If the cardinality of...

Few ways of doing this and one is replacing the apostrophes with double apostrophes.

😎

Quick sample and quick correction on Drew's code.

DECLARE @Cleintslist TABLE

(

Cust_id INT IDENTITY(1,1)...

drew.allen (3/29/2016)

---

Eirikur Eiriksson (3/29/2016)

---

Quick thought, there is no need for the subquery as this can written as a normal query

😎

SELECT

C.cust_id

,C.cust_name

...

Quick thought, there is no need for the subquery as this can written as a normal query

😎

SELECT

C.cust_id

,C.cust_name

,C.cust_state

...

Further on Tom's fine answer, the uncommitted insert statement will be holding Sch-M lock that prevents concurrent access to the table.

😎

Run this in session 1 to observe the locks held...

szejiekoh (3/27/2016)

---

Hi Eirikur,

Thanks for your reply!

So actually SELECT will start a transaction as well...

q1) can you actually let me know what does @@option & 2 means ? ( i...

Stylez (3/23/2016)

---

Good Afternoon Guys,

I would like to ask is there a way for me To Optimize the way i insert My Data from A Temp Table To A Sql Table....

This is simply because the last select within the IMPLICIT_TRANSACTIONS ON section implicitly begins a new transaction...

Don't think that compression should be applied to everything in a database as sometimes the space gain is marginal which hardly justifies the compression.

😎

Below are two scripts, the first compresses...

Mac1986 (3/26/2016)

---

Hello All,

I have source table with column nvarchar(20). the data looks like below.

Duration

120:06:31.150

120:06:31.165

238:21:19.875

266:45:41.472

287:03:25.184

I need to dump it into destination and i do...

I would say more like 99.99% there:-D

😎

The article's code...

VoldemarG (3/24/2016)

---

If someone can give me a hand on how to most efficiently modify the attached SQL without a cursor (to turn multiple rows in a column into 1 concatenated...

Sean Lange (3/24/2016)

---

--I posted in another thread by accident a couple of days ago--

Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get the...

Can you post the full DDL for the tables, indices, triggers etc.?

😎

vs.satheesh (3/23/2016)

---

HI

I am using date add Query for following method

update OfflineExamScheduleMaster

set edatetime=dateadd(mi,50,getdate()),

I got the result for example...

2016-03-24 11:52:16.207

But i want following format

2016-03-24 11:52:00.000

I want Milli secong and...