Good point - didn't consider just...

The best way is to use a Tally or Date table and join to it where the date's between your date ranges to expand the date ranges into individual days....

GNUPG stores the stored encryption keys in the user registry space - have you logged on to the server as the service account and created the keys as this user?

Does...

Correct.

Have a look at the output of:

DBCC SQLPERF(logspace)

Before and after a log backup

No, it does not reduce the size of the file, just makes the space available to be written to again. But unless it was an unusual operation that caused it...

You've just got an extra opening bracket that you never close:

select * from sampletable where

(replace(country,' ','')= input_country

Should be:

select * from sampletable where

replace(country,' ','')= input_country

That's the physical limit, but it's not a guarantee that it will perform well up to that number.

You should have some very serious hardware specifications to expect SQL Server to...

As far as I'm aware, regardless of where the data is sorted, the transaction log of the user database must fully log the operation to enable Rollback.

In an Online Index...

In any case, the question is entirely invalidated by the fact that they say they want to do this as they don't have space to store them. If absolutely nothing...

shield_21 (9/1/2010)

---

Hi there,

Putting comma on left or right side has no impact on performance.. 🙂 The syntax is just the same..

I think people put it on the left side...

Firstly, shrinking the database is possibly the worst thing you can do for performance.

Have a look at Gail's article for more information:

http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/

If the database is constantly growing, shrinking is also...

Does the stored procedure have a TRY...CATCH block within it?

I would expect that to throw an error in normal circumstances...

It's not gibberish, if you post the execution plan XML along with the actual query people will likely be able to suggest improvements - for a start, why are you...

Assuming these are varchar/nvarchar fields, then if there's no data in that substring range (e.g. the field length is shorter than 613 chars) then it will return a blank string...

Also, a quick question. Is for example child4 truly a child of child3, or is it just a child of parent1? If it's the latter, then the data shouldn't be...