soundex returns 0000 whenever a non A-Z,a-z character occurs: so commas hypens, numbers or the quote all give you misleading data.

personally, i had always stripped out the values fromt...

another longshot: if CDC is enabled for your table, you could get the values fromt hat:

--find any tables that are tracked via Change Data Capture

SELECT

name...

which script are you talking about?

did you run...

here's another version i had slapped together once;

this is specific to SQL 2008 and above, becuase it's also scripting filtered indexes and include columns;

i never bothered fleshing out the partitions...

the only way is to restore from backup.

if you were not inside an explicit transaction you created, the change would be committed immediately, with no way to reverse it.

if you...

I'm not sure either;

in my CLR where i'm using a web service, i have an added web reference;

i'm hitting the web service directly;

i'm guessing that for you, it's really indirect,...

that's...

for the item that is running slow, can you try adding this option(optimize for ) to your query?

SELECT SUM(amount) [Total],SUM(number) [Number of Records],

...[snipped for clarity]...

) data

GROUP BY TransactionCurrency,TransactionType,TransactionCode,TransactionSubCode,SecondarySubCode

--this is what...

Yes this is all true, but I am not running it via the stored procedure- i am just running SQL code with the parameters passed directly , as in the...

yeah i'm more sure than ever it's parameter sniffing, and nothing to do with synonyms at all;

my first clue:

if @EndDate is Null

select @EndDate = getdate()

i'll assume that the costructor for...

I'm thinking the issue has a...

I had built a prototype CLR that i thought would work, but i didn't have PGP installed on my work machine for testing.

here's the CLR code i thought would work,...

it's an excel thing: simply highlight all the cells, right click and Choose format Cells...

the popup window choose "Text" fromt e available options.

tim.cloud (7/3/2012)

---

I just finished setting up a server that does exactly what you need. In fact, here is what I setup:

1.) A single core VM with a single drive...

CELKO (7/3/2012)

---

The short answer is that good programmers do not use table valued functions. They are proprietary, screw up the optimizer and require disk access so they are slow.

Instead...