this query specifically gives me the server/database/table/column that was used int eh output list of the query.

maybe this gets you what you were looking for?

i had to create a linked...

UPDATE SomeTable

SET Column =

CASE

WHEN condition = 'HF'

THEN SomeCalculationOrValueOrColumn

WHEN condition2 = 'AST'

THEN ADifferentCalculationOrValueOrColumn

END

AFAIK there's no view that would capture references in dynamic queries DIRECTLY;

you could look at cached execution plans, and parse the xml of the plan for server/database/schema/table; but that's only...

i don't think you can find that, AFAIK all you can find is the last execution time; you cannot see , for...

I just noticed every one of us skipped over a basic group by as an alternative, and went straight to row_number.

this is probably the simplest:

SELECT

name,

...

no, there are no events for triggers to capture that affect linked server access.

in the screenshot above, if they are not mapped, they have...

yes.

on this screen of the linked server properties, simply make...

moved to original post.

azenon (8/2/2013)

---

Hi All,

I have 80gb of free space in a database after unused tables/index and old table data was deleted. I am hoping the data file size does not...

i have this saved in my snippets as the top 20 slowest performaning queries;

this might get you started:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SELECT TOP 20

CAST((qs.total_elapsed_time / 1000000.0) AS DECIMAL(28,2)) as...

ok, you have a requirement that is a little scary for me (ALL bit flas no matter what/all varchars no matter what)

*note this is changing ALL CURRENT DEFAULT VARCHAR FIELDS...

halifaxdal (8/2/2013)

---

Thanks.

Then how do I loop each field and find if there is a constraint on it? and get the constraint's name if I have to put the name there...

basic example:

CREATE TABLE [dbo].[SALESDATES] (

[ID] INT IDENTITY(1,1) ...

halifaxdal (8/2/2013)

---

I have a database with tables to be updated so that all varchar fields will be given a default '' value and all bit fields will be given 1

I...

i'm not sure what you are after here, might need a little clarification.

Are you talking about Data Masking like this article? Where you obfuscate/replace sensitive data on a copy of...