Viewing 15 posts - 3,781 through 3,795 (of 49,552 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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2016 at 1:00 am
My question would be 'why'?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2016 at 2:50 pm
Table definition, index definitions and execution plan please.
But first, is the query really a problem?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2016 at 9:42 am
TDE is a database-level setting, not a server/instance setting.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2016 at 2:36 am
Viewing 15 posts - 3,781 through 3,795 (of 49,552 total)