Lukewarm support for ODBC? But Microsoft keeps stated the following back in 2011 and keep repeating it.

ODBC is the de-facto industry standard for native relational data access, which is supported...

The smarter managers, the ones who have a track record of delivering and cultivating the best teams, they have a basic mistrust of employees who act like a know-it-all.

In...

Or you could leave the columns as is and add page compression, which in this case would probably shrink the table down to 10% or less of it's original size.

It's strange that there would be about 850 columns containing nothing but NULL. Apparently the original DBA has long since left and can't be sought for guidance.

If the columns truly...

There is a free tool called 'Data Health Monitor' at databasehealth.com. You basically point it to a SQL Server database, and it performs a variety of analysis at difference levels,...

So, it didn't estimate any...

Pages in SQL Server tables are basically 8 KB. Data pages can be IN-ROW or ROW-OVERFLOW (contained off-row in space reserved for LOB), and Page or Row Compression works on...

Are you wanting to know what tables have a foreign key dependency on a table's primary key?

You can use the following procedure call, specifying the primary key table.

sp_depends '<object>' ...

How are you containing the "XML files"; as XML datatype, varchar(max), filestream, etc. ?

GilaMonster (11/3/2016)

---

Neither page nor row compression will compress LOB columns (like XML), so it's not as easy as just ALTER INDEX (and the sp_estimate_data_compression_savings is only going to estimate savings...

SQL Server 2008 supports row and page compression. I havn't heard anything about improvements to the compression algorithm in 2014.

You can estimate the compression savings on a table using the...

Rod at work (11/2/2016)

---

David.Poole (11/2/2016)

---

Terry Pratchett described how the city of Ankh Morpork dealt with a plague of rats by paying a bounty on dead rats delivered. Despite this...

Sean Redmond (11/3/2016)

---

The horrifying thought is that Microsoft will start to include the coffee-factor into their licensing calculations. Enterprise Edition users are allowed unlimited cups of coffee and a better...

Rod at work (11/3/2016)

---

Eric M Russell (11/2/2016)

---

kiwood (11/2/2016)

---

Eric M Russell (11/2/2016)If IT was providing executive management with reports indicating an unusual spike in the number of new accounts opened and...

That depends on how much budget our company has allocated to coffee.