hemabalan (12/30/2015)

---

Thanks for the response.

Heres another one. Using CTE I undestand we dont have to worry about storing and retrieving from tempdb. It works as we have the USING...

You really need to provide us with full table definition...

david.holley (12/29/2015)

---

Thanks for the responses. In Googling around, it's interesting to see the responses to the issue. I'll probably keep the true .net errors for 90 days and the advisory...

Binoogle search for the words merge bugs sql...

Luis Cazares (12/28/2015)

---

Eric M Russell (12/28/2015)

---

TheSQLGuru (12/28/2015)

---

Ooh, another thing I will chime in with. Some of the WORST things I see done on SQL Server have nothing to do with...

Welsh Corgi (12/28/2015)

---

I very much appreciate all of the help.

I'm only dealing with 50,,, records.

When I performed the archive I had a lookup table that stored the Batch Size etc.

Can...

It actually isn't quite as easy as you probably think it is. There are at least 4 issues that can cause you pain:

1) locking/blocking

2) crushing your server (IO reads,...

Ooh, another thing I will chime in with. Some of the WORST things I see done on SQL Server have nothing to do with the databases/applications they run - it...

I have spent a large portion of my 20 years consulting on SQL Server doing tuning work in some fashion or another. The single worst thing I see in aggregate...

Jason A. Long (12/25/2015)

---

TheSQLGuru (12/25/2015)

---

How about I do a remote presentation of my Common TSQL Mistakes session? I have presented it somewhere around 100 times now for companies, User Groups,...

How about I do a remote presentation of my Common TSQL Mistakes session? I have presented it somewhere around 100 times now for companies, User Groups, SQL Saturdays and other...

baiju krishnan (12/24/2015)

---

Hi,

I want to write a stored procedure with if condition

i have two tables

Login

-------

uname|pword|active

-----------------------------

Lekshmi|baiju |0

Jain ...

Yes, shrinking will be DEVASTATINGLY BAD due to the internal fragmentation it creates in all of your tables/indexes. Why can't you just leave the database the size it is? Is...

Hitting the clustered index is hitting ALL THE DATA for each seek/scan. Remember, the clustered PK IS the data at the leaf level of the index. All that is on...

Jeff Moden (12/22/2015)

---

TheSQLGuru (12/22/2015)

---

Partitioning CAN make PROPERLY DESIGNED report queries go much faster when partition elimination can allow said queries to hit a small fraction of the total data. There...