Viewing 15 posts - 6,646 through 6,660 (of 8,416 total)
Peso,
You muse be psychic to get that from the first post and this:
rshm35 (11/9/2009)
i can not use indexed view..help me...
November 11, 2009 at 12:39 am
You cannot usually* attach a database that was detached while in STANDBY.
The process of placing a database into STANDBY writes to an file that you specify. The file contains...
November 10, 2009 at 9:50 pm
Whether it is 64- or 32-bit makes no difference. What does matter is the version of SQL Server.
You can't restore a backup from a 2008 SQL Server to a...
November 10, 2009 at 9:18 pm
chk2009 (11/10/2009)
Thanks for your reply:-)How can we do that, can you pls explain me in detail, which command to use.
It's all documented in the link I provided before. Just...
November 10, 2009 at 9:12 pm
Just for anyone who's really into this: http://blogs.msdn.com/raulga/archive/2006/03/11/549754.aspx
Otherwise, yes, indexing the encrypted value can be useful (and better than a full scan of the table!), so long as you don't...
November 10, 2009 at 9:10 pm
chk2009 (11/10/2009)
Can we take tail tlog backup even when db is offline/damaged/correpted
Yes. Tail Log Backups
November 10, 2009 at 9:01 pm
A 2005-specific version:
;WITH NonclusteredIndexes
AS (
SELECT [schema_name] = SCHEMA_NAME(SO.[schema_id]),
...
November 10, 2009 at 6:05 pm
george sibbald-364359 (11/10/2009)
you can call me just george sibbald. Despite that darned number suffix which I hate I am the only george sibbald on the forum. 🙂
George,
You can change that...
November 10, 2009 at 5:25 pm
Is the table concerned used in any indexed views?
The part of the plan that maintains indexed views runs at the SERIALIZABLE isolation level, regardless of the isolation level in effect...
November 10, 2009 at 4:48 pm
GSquared (11/10/2009)
SSIS requires a fixed number of columns in the import definition.
Well it certainly prefers to deal with stable metadata, that's for sure. But, unless the requirement is actually...
November 10, 2009 at 3:33 pm
Louis,
No it won't affect your snapshot replications.
Paul
November 10, 2009 at 2:36 pm
There's no pleasing some people!
November 10, 2009 at 2:31 pm
Grant Fritchey (11/10/2009)
I've got a new monster lurking in the wings though, a DB built entirely with, by and for nHibernate. Should be another great source for material.
The mind boggles...let's...
November 10, 2009 at 2:30 pm
sindbad7000 (11/10/2009)
Thanks alot it works... now it retrieves the 5200 records in only one second...thanks alot again i appreciate that alotbut please may i ask about the tools you used??
I...
November 10, 2009 at 2:27 pm
david.wright-948385 (11/10/2009)
... or use merge.
...2008 only. (This is the 2005 forum!)
November 10, 2009 at 2:17 pm
Viewing 15 posts - 6,646 through 6,660 (of 8,416 total)