http://source.entelect.co.za/why-is-this-upsert-code-broken

also check networking:

microsoft ldap port 389

I run into this sort of networking often, with today's vlans and other segmented mess, any given route in your organization can block a port,...

any differences in the sql server's service account itself? just curious, I've only used the ldap queries a few times and they worked from the get go but was curious...

if you transfer table by table, how are you going to be assured of a consistent view of the entire database? Are you going to leave the source table inactive...

sqlfriends (11/7/2016)

---

A further question, if function are not worked efficiently, why T_SQL has this table valued functions?

In which case we should create functions?

I can think of is for calculation, parse,...

CELKO (10/26/2016)

---

>> I want a SQL function that will allow to make one update but with several replace on the same column. <<

UPDATE Foobar -- we have no DDL or...

this wasn't exactly my favorite editorial of all time.

I notice that you bump up system load to find concurrency problems, another method is to introduce "waitfor" statements in your stored procedures in between updating separate parts of your...

latitiacasta (10/20/2016)

---

I have requirement when one transaction select records and update status same time another transaction also do the same thing. I have put (nolock ) in select query...

I just am having trouble how to reorganize a table that size and get away with just 24 gigs of tlog activity.

When I look at the table and count the...

Brandie Tarvin (10/20/2016)

---

Jeff Moden (10/19/2016)

---

Steve Jones - SSC Editor (10/19/2016)

---

Jeff Moden (10/18/2016)

---

Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.3...

"clustered index" means the base table, so you are essentially rebuilding or reorging the base table.

Brandie Tarvin (10/19/2016)

---

patrickmcginnis59 10839 (10/19/2016)

---

Anything could cause the secondary to not be synchronized. Things like taking differential database backups of the primary, which will disrupt the flow of data from...

Anything could cause the secondary to not be synchronized. Things like taking differential database backups of the primary, which will disrupt the flow of data from primary to secondary. (AG,...

Index reorgs / rebuilds?