A lot of us here became DBAs back when there weren't a lot of books on the topic. I'd start by looking at the eBooks published by Redgate and Brent...

So, in a smoke test what you should really be looking for is not functionality... but smoke.

- If deploying a DDL script, scroll through the output window and look...

My understanding is that, at least by default, when given a VARCHAR(MAX) column, SQL Server will only store the data offrow, if the total data size for a row doesn't...

You can use Project Parameters and Expressions to specify things like server names and network paths at runtime. The value of the parameter can be set from the job...

Government IT departments, at least at the state and federal level, are well funded, and IT platform tools they use are similar to what you would find in the corporate...

- Sometimes (usually not) an application will populate the Program property of the connection with something like the user's login name, so when qyerying the SQL Server connections DMV, examine...

When we talk about versioning and...

I've survived many rounds of layoffs at several different corporations, so I've been fortunate in that regard. What I've noticed is that the guy with the jack-of-all-trades or internal consultant...

SSIS does a good job of manipulating rows and columns within buffers as it moves through the pipeline, but sometimes loading the data into target table as fast as possible...

Every IT organization I've ever worked for has had a Patient/Customer/Student search application similar to this, and optimizing this type of thing is a classic problem. My default advice is...

Hi Rod,

Google: filetype:xlsx new mexico counties population

http://www.census.gov/popest/data/intercensal/county/tables/CO-EST00INT-01/CO-EST00INT-01-35.xls

As for your network connectivity issues, please email help desk support. 🙂

The same goes for non-clustered indexes; in terms of query predicates, column position in an index matters.

To be sargable, the query would need to filter on the leading column in the index.

For example, assume we have CLUSTERED INDEX ( StoreID, TransactionID, ProductID ). A query WHERE...

Unless the log growth was the result of a one-off process and the disk space is shared by other databases, I don't see the point in shrinking. Maybe focus on...

Ed Wagner (8/16/2016)

---

Eric M Russell (8/16/2016)

---

Ed Wagner (8/16/2016)

---

Eric M Russell (8/16/2016)

---

It would be useful to have an experienced gray haired DBA who could offer technical assistance and architectural advice across...