Forum Replies Created
Viewing 15 posts - 5,641 through 5,655 (of 49,571 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... -
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...
-
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...
-
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.
-
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?... -
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...
-
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...
-
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,...
-
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...
-
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...
-
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...
-
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...
-
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...
-
RE: Encrypt SQL server 2014 instance
First identify what needs encrypting. You'd never encrypt every column, just columns containing sensitive data.
-
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...
Viewing 15 posts - 5,641 through 5,655 (of 49,571 total)