I was almost sure that my options "Enable backup compression" and "Create a user that is classified into a limited CPU workload group in Resource Governor" were right. Resource Governor...

I agree with Gail. Try to comment that UDF to see if it improves performance.

I see some UDFs everyday with heavy calculations and loops that cause performance degradation.

There's just so much information in the this article and discussion!

Please keep up the good work.

Many books don't expose the level of detail presented here and leave us wondering how...

Easy and straight-forward question.

Thank you.

And when I need to use something similar in MSSQL 2000 or 2005 I write this:

INSERT INTO dbo.Table(Column1, Column2)

SELECT 'Value1', 'Value2' UNION ALL

SELECT 'Value3', 'Value4' UNION...

Now that was something I didn't know about.

I knew the answer wouldn't be leprechaun though. 😀

Thank you for the question.

Thank you for that link.

The discussion following that article is excellent as well.

Just a quick and silly reminder:

select

substring(pagename, 1,charindex('/',pagename)-1) as sitename, -- or LEFT(pagename, charindex('/',pagename)-1)

count(*) as cachecount

from systempagecache

group by substring((pagename), 1,charindex('/',pagename)-1)

order by cachecount desc

It's valid because the ORDER by...

My lack of experience with offline databases led me to the conclusion that the NORECOVERY option was always needed in tail log backup. But I should have known there was...

I must apologize because my last post seemed harsher than I intended it to be.

I was in a bad mood last night and didn't chose the right way to express...

have2much (1/9/2012)

---

I believe it's a technical forum where we are discussing and helping other to find out a resolution. At times we may not very sure about the things and...

I understand that something like this should work:

COUNT(*) OVER(Partition by datakey) / COUNT(*) OVER(Partition by landline, datakey) AS Uniquelandline,

COUNT(*) OVER(Partition by datakey) / COUNT(*) OVER(Partition by mobile, datakey) AS Uniquemobile,

COUNT(*)...

Hi.

Could you please post and example that shows how're you using your FullText code?

[EDIT] AFAIK you'd be fine using CONTAINS or CONTAINSTABLE.

Best regards,

Modified stephen's code a bit:

declare @t table(indkey nvarchar(2),datakey nvarchar(4),landline nvarchar(11),mobile nvarchar(11),email nvarchar(20))

insert into @t values ('1','0001','01234567890','0712345679','1@test.co.uk')

insert into @t values('2','0001','01234567890','','1@test.co.uk')

insert into @t values('3','0002','01234567891','','2@test.co.uk')

insert into @t values('4','0002','01234567890','','2@test.co.uk')

insert into @t values('5','0002','','07123456789','')

insert into @t...

You could also use a CLR assembly with code to do that but it depends on the environment and the security of the server. It's a bad idea to leave...

I just had the same problem here tonight.

I was making a little test creating extra files for tempDB and ended up with this weird behavior.

Has anyone experienced this? Is this...