Disk space truely is cheap. Yes, we can get a lot more storage space for our money today, but the I/O speed hasn't kept up at the same pace. So,...

GilaMonster (8/11/2015)

---

Grant Fritchey (8/11/2015)

---

Updating statistics won't change the names...

Alvin Ramard (8/10/2015)

---

GilaMonster (8/10/2015)

---

You can do it, but it is not a good idea. It's liable to cause you problems down the line. Just write one proc for insert, one...

This can also happen if your query's execution plan is creating extremely large hash tables or sort operations in the background and spooling out to tempdb.

Use the following DMV query...

INSERT / UPDATE operations can be consolidated gracefully into a single MERGE statement, and the input parameter, perhaps an XML datatype, would be the same. So that could be one...

I answered a similar question last week.

"MATCH NAME IN DIFFERENT TABLES WHERE NAME ORDER IS REVERSED"

http://www.sqlservercentral.com/Forums/FindPost1709265.aspx

The following script will return, for each statement in the specified stored procedure:

sql text, last_elapsed_time, last_worker_time (CPU), last_blocked_time (waiting on lock), last_reads, last_writes, last_rows returned, and plan text, ... etc.

For...

I know you're just talking hypothetical to make a point about source control dilligence and what we could do, if we believed it was maintained perfectly. However, it's hubris, not...

Regarding the topic of busting stereotypes regading what a software engineer looks like, I found this recent article.

... Comments on Facebook and Twitter started piling up, dissecting her appearance —...

It would have been funnier had the subject of the cartoon been portrayed as a potbellied male DBA posing as a reclining Adonis. However, I'm sure it still would have...

Looking at the internals of the stored procedure and considering the table is 21 million rows, I'm impressed that it would run within 5 seconds. Unless you completely overhawl the...

It looks like name coding is not conformed even within the same table, but you can work around this by unionizing multiple selects, each with an alternate join expression to...

Miles Neale (8/6/2015)

---

Being successful and appearing to be successful are two different things.

I get a kick out of some judges on American Idol or America's Got Talent when they say...

If you have an SSIS package with a bulk load task and option 'Check Constraints' turned off, then it will automatically alter your check constraints to disable them prior...

XYoung (8/6/2015)

---

janet.stockton-taylor (8/6/2015)

---

I did not say that it exists "everywhere". You're the only who said that. Perhaps you, while you worked in those "dozens" of shops, viewed the workplace...