Forum Replies Created
Viewing 15 posts - 5,641 through 5,655 (of 49,552 total)
-
RE: Query Performance Tuning – A Methodical Approach
FootyRef (6/9/2015)
I want to bring that partition month into its own staging table, do the inserts and updates and then switch it back to the original fact table from...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: SQL Server Data Lost on User DB's
ericpap (6/9/2015)
Still triying to find out how can data be lost after the service where stopped.It can't, unless the database files were replaced or something was run before the service...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: TDE Table Data Encryption
BL0B_EATER (6/9/2015)
I am sure there are a few but the only one I am aware of is that you will probably see an increase of CPU with TDE enabled.Likely, but...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Query Performance Tuning – A Methodical Approach
Indeed I didn't. My bad.
The plan's cost is over 200, so it doesn't need any help going parallel.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Query Performance Tuning – A Methodical Approach
FootyRef (6/9/2015)
So, I can't switch, say, four partitions out into a staging table, do inserts and updates against data in those partitions and switch them back into the fact table?...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: SQL server Trigger
Why write it that way? Why not just a
INSERT INTO ...
SELECT ... FROM deleted
?
When you write triggers, you must assume that the inserted and deleted tables have multiple rows...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
spaghettidba (6/9/2015)
GilaMonster (6/8/2015)
Well here's a new slant on the 'partitioning for performance'...Switch the partitions that are needed out to a staging table, do processing on the staging table then...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Query Performance Tuning – A Methodical Approach
FootyRef (6/9/2015)
I only want to do the switching of partitions when running the daily ETL processes.You've talked about having monthly partitions and switching partitions out of the fact table,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: TDE Table Data Encryption
Welsh Corgi (6/9/2015)
It needs to be enabled to prevent sensitive from being displayed?Nope, it does not do that.
Column encryption is what prevents someone unauthorised from querying data.
Why are you using...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
BL0B_EATER (6/9/2015)
GilaMonster (6/8/2015)
Well here's a new slant on the 'partitioning for performance'...Switch the partitions that are needed out to a staging table, do processing on the staging table then...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: SQL Server Data Lost on User DB's
ericpap (6/8/2015)
4) After that I see on the log constant message from CHECKDB over my users database (a lot of them) wich no one execute.Databases with Autoclose on? Every time...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Well here's a new slant on the 'partitioning for performance'...
Switch the partitions that are needed out to a staging table, do processing on the staging table then switch 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Different Kind of indexes - Questions
Well firstly a primary key isn't a type of index. A primary key is a table constraint that requires that the column is not nullable and unique. A primary key...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Encrypt SQL server 2014 instance
First identify what needs encrypting. You'd never encrypt every column, just columns containing sensitive data.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Query Performance Tuning – A Methodical Approach
FootyRef (6/8/2015)
GilaMonster (6/8/2015)
FootyRef (6/8/2015)
Say my source data is only looking at April, May, June, July and August. I want to use that information to swap those partitions from...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 5,641 through 5,655 (of 49,552 total)