very very useful for me, indeed. great job.

I might remember a post i saw two weeks ago,and want to find it;

now with the Relevant First, it's muche easier to page...

open the file up in an enhanced text editor like NotePad++;

you'll be able to see what the row terminator actually is.

i think \r maps to CHAR(10), and \n is...

just like the repair for any other item that was installed with windows insaller:

reviews any dll's , exe's or ocx's, as well as files for differences in the saved .msi...

my best guess; not sure what you expect on the last record, it doesn't seem to follow the right pattern, but at elast with a framework like this, oyu could...

Ashwin M N (8/2/2013)

---

I have to replace XX database from backup in production. The third party tool and reporting services have been configure to database id so I want to...

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...