Thanks Luis,

Your explanation and approach makes lot of sense. And the next time I come across such situations I will use the suggested approaches. Looks like cross tab is the...

Hi Iwas,

Most analytics/transformation tasks will require

these kind

of twisty sql/tsql code. As commented by

One of the readers above, it is apparent that this

is only one of the...

Hi,

That was a great article. I have been doing many home-grown-solutions at various placed I had worked for almost 10 years to get SQL Server objects into source control.

Just Recently...

Thank you very much SSCCommitted for that correction.

It was too scary, and I was almost about to talk to my DBA friends

in different companies. That would have not been a...

sorry that is a factual error:

The frequency at which the statistical information is updated is determined by the volume of data in the column...

Alex is my long time DB mentor/guru. Thought his feedback on this may be useful for others.

Greetings,

I'll try to elaborate on this one...

As defined in MSDN - When statistics are...

hankz much Sam. I am a dumbo. Many times I myself have turned off AUTOSTATS because of performance reasons. But yesterday could not catch...

Aha! thank you very much Greg!

for the benefit of others:

create table PrefixCreator1(f1 text)

create table PrefixCreator2(f1 image)

create table PrefixCreator3(f1 text, f2 image)

select *

from sysindexes

where name = 't' + object_name(...

Only if the source and destination table have the same clustered index, can we assume some order. Even then, after the data transfer, if the index is disabled from the...

pl see if table valued functions could help:

create function f1()

returns @t1 table(f1 int)

with schemabinding

as

begin

 insert into @t1 select f1 from dbo.t1

 return

end

select count(*) from f1()

one way to approach this would be to create the first query as a "View"

i have not worked with the Express edition, but can you please try this:

select * from msdb..sysjobs

please write it as a stored procedure and call it from the job

That is Awesome Steve, you wrote two books in one year. Can't believe, with the kind of load you have everyday.

On my part, though I have been working with databases...

that touched my heart Bob. specifically this paragraph...

The real heroes in my life are those that go out of the way of normal life to help others. God and parents...