Viewing 15 posts - 3,781 through 3,795 (of 49,571 total)
You're going to have to explain the problem in a lot more detail please, I can't understand. Code may very well help.
January 21, 2016 at 6:37 am
salardx (1/21/2016)
1- if some bytes of the main file (mdf) get corrupted for any reason (hardware problems mostly) there's high probability that the whole table become unavailable!
Nope. If a...
January 21, 2016 at 5:04 am
Alexander Suprun (1/20/2016)
It's actually quite strange why optimizer decides to scan the whole index instead of performing few hundred seeks of the same index.
The keys are in the wrong order....
January 21, 2016 at 3:35 am
Roust_m (1/20/2016)
Given that not clustered indexes get rebuilt when a clustered index gets rebuilt...
They do not, unless you're changing the keys of the clustered index. If you are, drop the...
January 21, 2016 at 1:00 am
My question would be 'why'?
January 20, 2016 at 2:50 pm
Table definition, index definitions and execution plan please.
But first, is the query really a problem?
January 20, 2016 at 2:44 pm
djj (1/20/2016)
I missed if anyone ever found the crystal ball?
It's in a quantum state. At best, sufficient need can collapse its waveform temporarily and cause a sudden burst of clarity,...
January 20, 2016 at 1:16 pm
Eirikur Eiriksson (1/20/2016)
Alvin Ramard (1/20/2016)
Ed Wagner (1/20/2016)
Steve Jones - SSC Editor (1/20/2016)
January 20, 2016 at 1:14 pm
bcp will work for the data. You'll have to script out the tables, with keys and indexes and recreate then in the destination DB first.
January 20, 2016 at 10:04 am
DB Backups don't have passwords. You'll need to have the same certificates (well, the ones used for TDE) on both servers.
January 20, 2016 at 10:02 am
Rather get a backup restored somewhere you can test. Because a test table with dummy data will behave differently.
January 20, 2016 at 9:42 am
TDE is a database-level setting, not a server/instance setting.
January 20, 2016 at 9:40 am
EasyBoy (1/20/2016)
This index is already exist.
CREATE INDEX [ix_tblEventSample_FkSample_fkEventtype] ON [dbo].[tblEventSample]([fkSample], [fkEventType]) WITH FILLFACTOR = 97 ON [INDEXDBGROUP]
GO
No it doesn't.
Andrew recommended an index with the key fkeventtype, fksample. The...
January 20, 2016 at 8:33 am
Why not just delete all the duplicates in an initial pre-processing step, rather than one at a time after an error?
January 20, 2016 at 3:54 am
Short of scripting it all out, no. When you restore over an existing database it's completely replaced.
January 20, 2016 at 2:36 am
Viewing 15 posts - 3,781 through 3,795 (of 49,571 total)