Viewing 15 posts - 2,821 through 2,835 (of 3,061 total)
my choice would be a Full Table Scan in your larger table, then pack the predicate with as many inline views as you can, all of them doing Full Table...
October 30, 2008 at 2:51 am
Either your specs are wrong or your test data is wrong.
All your rows have -1 value either on field3 or field4 columns so your query would return no rows; by...
October 29, 2008 at 6:02 am
I'll put the database in restricted mode...
Take a full backup -be sure the backup is good...
Bring down SQL Server services...
Do the disk swap...
Light a candle...
Start SQL Server services...
Check error log.
October 22, 2008 at 5:38 am
Shall we understand the initial and final location after the "move" is the same?... kind of taking a backup of a specific disk-drive, replacing the affected disk-drive and then restoring...
October 22, 2008 at 5:21 am
yulichka (10/21/2008)
In commerce server I need to give user only permissions: insert, select,update,delete in a tables. I know in regular server: it's db_datareader and db_datawriter, what about on Commerce Server?
It...
October 22, 2008 at 1:44 am
...or search Google for "SQL Server, OLTP, performance, reliability, scalability, security" 😉
October 22, 2008 at 1:42 am
Providing you are following Kimball's guidelines therefore your Data Warehouse is nothing but a collection of star-schema Datamarts I would say the standard ETL should works pretty much this way...
October 22, 2008 at 1:39 am
Would you mind in posting the error message?
Can you see any related message on the Error Log?
October 18, 2008 at 9:42 am
:blink: huh?
1- Breath
2- Rework your post
October 17, 2008 at 8:35 am
Okay... let me break the news for you: it is not how many potential users you have, it is how many are concurrently working on the system and how complex...
October 17, 2008 at 8:16 am
I see you have implement some sort of a standard backup procedure all accross the board.
In my opinion Backup/Recovery strategy should be customized for each database according to business requirements...
October 17, 2008 at 4:32 am
I think there is no silver bullet...
DDL, I remember a schema-version column on sysObjects that would tell if the object was ever changed but it does not records the timestamp,...
October 16, 2008 at 5:39 am
Are you talking about DML or DDL?
October 16, 2008 at 5:10 am
Viewing 15 posts - 2,821 through 2,835 (of 3,061 total)