What's your backup frequency ?

You may experience the result of IO shortage.....

If you have online index rebuilds, tempdb will be used !

This may cause read/write contention with tempdb file(s)...

In fact a snapshot db is created without any entries !

Data is only inserted if rows are modified in the originating database (or objects altered/dropped).

That's why a snapshot db only...

No.

A shapshot only preserves the state at the moment it has been taken !

So it only contains a single truth about a row at a certain point in time.

Keep in...

so that would be a rbar promotion ?

I know I'm way off, but in would a pivot help to determine the set ?

IF object_id('v_SSC_Assignment_InstructorCorse') IS NOT NULL

...

With a system as yours that is apparently vulnerable to fast degradation of statistics, and that doesn't perform well after the daily updatestats I would try to disable the daily...

just remove @ from your connectionstring and you should be ok

If sqlbrowser service is running, you don't need to supply the port number (,13...)

Then you can remove that...

Have a look at :

- "Moving Large Table to Different File Group" http://www.sqlservercentral.com/articles/Administration/64275/

- "Moving Tables and Indexes to Filegroups En Masse " http://www.sqlservercentral.com/articles/Files+and+Filegroups/65538/

- "Move a table between filegroups" http://www.sqlservercentral.com/scripts/Miscellaneous/31526/

Such operation will be noticeble for ongoing operations !

Can you afford downtime ?

If yes,

Can you move the whole db file, or do you want just to...

I think in this case it is worth the try.

Did you perform datapurity checks after you restored the db ?

http://support.microsoft.com/kb/923247

mikesigsworth (5/7/2009)

---

The @Value is coming from an ASP.NET business object. So should I be doing a search and replace for the _ character and using the ESCAPE thing? Seems like...

As shown in my previous reply a password encrypted master key can only be modified using the path of:

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'TestEncryption31' ; -- old...

So this proves you actually have NULL s in the designated date column !

Since you didn't order the first time, these rows will have been some where random in the...

Your variables content must match the predicates conventions.

In this case the conventions for Like.

Did you test this :

SET @Value = N'%My[_]Matching[_]Value%';

skjoldtc (5/7/2009)

---

I find the intellisense helpful in SS2008. But then, I haven't coded in T-SQL forever. I've gotten used to the intellisense in Visual Studio. Maybe that's helped me use...