Brian J. Parker (2/12/2015)

---

Steve Jones - SSC Editor (2/12/2015)

---

Brian J. Parker (2/12/2015)

---

Gosh, I'd be surprised if any DBA or database developer did NOT have a folder full of T-SQL scripts...

Jeff Moden (2/12/2015)

---

Killing even the most ridiculous users sessions is a really good way to need an updated resume. I know it takes a whole lot longer to do...

jchapman (2/12/2015)

---

Clever idea... I had not thought of that. The big question would be if that change kicked in immediately (changing the behavior of existing open connections, and possibly...

Well, it's good to hold on to our ideals... but we must also carry a big stick. First try to educate and...

It's odd that the developers would be writing SQL involving complex sub-queries in a data warehouse. Perhaps it's not a star-schema or they're not familar with the data model.If you...

Assuming there is only one DBA, and you're now it (perhaps the last one left unexpectedly), then taking an inventory of your IT environment is important, but perhaps not the...

Changing the ordinal position of columns in the ORDER BY clause can cause a change in the execution plan. If the ordinal position matches an index, then it can leverage...

The order of columns in the insert does not matter to the optimizer or engine. Also the order of columns in the SELECT, WHERE, and JOIN do not matter.

First,...

If by deploying often we mean more iterative and incremental deployments, then that can also result in safer deployments, because changes within each release are fewer and more manageable. It's...

Rick Todd (2/10/2015)

---

The reason it appears RBAR is that if I check the number of rows in the floats table over and over it goes down by 1 every second...

jarick 15608 (2/10/2015)

---

I think the marketing hype of NoSQL has made a lot of managers and educators start to think that the RDBMS is dead. They said the same...

You can attempt the following, but I doubt it would work, even if the target were another SQL Server instance.

INSERT INTO MYSQL..OC_Abiertas

( DocNum, DocEntry, DocDate, CardCode, CardName, SubTotal, DiscPrcnt

,...

I've found that building up a list of keys shared across multiple tables into a temp table using EXCEPT keyword is very efficient. Deleting or updating against an inner join...

Reply back with the actual OpenQuery statement.

ALTER DATABASE <database> SET RESTRICTED_USER WITH...