Just doing a Google search on filetype:mdf turns up a lot of hits. Some of them are references to NorthWind or AdventureWorks, but others it's not clear. I havn't tried...

A prepared query is paramaterized and can be...

Sadly, in most IT shops it's the application developers to do most of the "interesting" database development work, and even the most senior members of the DBA team perform post-deployment...

As a start, you can combine sp_MsForEachDB with a query against INFORMATION_SCHEMA or SYS views.

For example:

-- Search for all stored procedures and views that include a keyword in their definition:

exec...

Budd (11/18/2016)

---

PLEASE tell me what needs to be done to make something like this work?

DECLARE @PARAM1 VARCHAR(2000) = 'Tom','JOE','BUDD','TIM' --< Obviously this wont work

Select name from employees...

I doubt Microsoft would let the ETL/Integration and BI components...

ZZartin (11/17/2016)

---

...

I happen to really like the windows 10 UI, it's a nice blend of the old windows UI with the better elements of the metro UI available in a...

While the original approach of excluding "enterprise" features from Standard Edition was to encourage folks to splurge on the Enterprise Edition license, as we see now, including these features in...

In terms of the Kimball methodology of star-schema modeling, I believe this would be an example of a "role playing dimension".

For what it's worth, the @@ROWCOUNT system variable contains the number of rows affected by the immediately preceeding DML operation.

What is the first policy?

Especially for lower tier servers (ie: 4 CPU / 8 GB memory), or instances where the database engine is the only service running, it's hard to justify the OS memory...

comic_rage (11/16/2016)

---

was able to improve the query by moving the isnull to the select and adding the column to a filtered index. Was able to reduce query time from 9+...

comic_rage (11/16/2016)

---

Hi,

I have the following query that is returning 1.6 M rows and about 300 columns. I can't change this factor. Here is the current

query

select Column1 ... Column290

from dob.table1

where...

In T-SQL there is an IGNORE_DUP_KEY option that can be added to the primary key. Unlike MySQL's ON DUPLICATE keyword, it doesn't result in an update for a row with...