Viewing 15 posts - 1 through 15 (of 73 total)
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...
October 22, 2015 at 9:05 am
Most analytics/transformation tasks will require
of twisty sql/tsql code. As commented by
One of the readers above, it is apparent that this
is only one of the...
October 22, 2015 at 7:59 am
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.
September 16, 2015 at 4:13 pm
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...
January 2, 2008 at 6:36 am
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...
January 5, 2007 at 10:02 am
Alex is my long time DB mentor/guru. Thought his feedback on this may be useful for others.
I'll try to elaborate on this one...
As defined in MSDN - When statistics are...
January 5, 2007 at 9:11 am
hankz much Sam. I am a dumbo. Many times I myself have turned off AUTOSTATS because of performance reasons. But yesterday could not catch...
January 5, 2007 at 6:27 am
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)
where name = 't' + object_name(...
January 4, 2007 at 12:55 pm
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...
January 3, 2007 at 7:02 am
pl see if table valued functions could help:
create function f1()
returns @t1 table(f1 int)
insert into @t1 select f1 from dbo.t1
select count(*) from f1()
December 29, 2006 at 8:09 am
one way to approach this would be to create the first query as a "View"
December 29, 2006 at 7:46 am
i have not worked with the Express edition, but can you please try this:
select * from msdb..sysjobs
December 29, 2006 at 7:15 am
please write it as a stored procedure and call it from the job
December 29, 2006 at 7:12 am
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...
December 29, 2006 at 6:58 am
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...
December 22, 2006 at 1:16 pm