Viewing 15 posts - 241 through 255 (of 476 total)
Mickey Stuewe (9/25/2015)
September 26, 2015 at 12:44 am
John Hanrahan (9/25/2015)
September 26, 2015 at 12:39 am
peter-757102 (9/25/2015)
When building a log table there is nearly always a chronological order that can be exploited.
Yup, agree with that, never spotted how I can exploit it though
Create the clustered...
September 26, 2015 at 12:20 am
peter-757102 (9/25/2015)
Additionally there should not be one big log table. It is better to have a manageable active table or partition and have older unchanging data reside in their own.
We...
September 25, 2015 at 1:30 pm
Minion Backup might be an alternative to Ola's scripts.
September 25, 2015 at 11:50 am
Log / Audit Data Changes
We log changes to data in an "Audit" table. It has exactly the same columns as the main table, but with two additional columns for Audit...
September 25, 2015 at 11:37 am
Script Run / Create SProc, Trigger, View etc. Logging
I log every "run" of scripts that Create an SProc, Trigger, View etc. The call to the Script Logging SProc, at top...
September 25, 2015 at 10:34 am
I have a Logging table which I use for all Page (website), Stored Procedure calls, and as a general log for unexpected errors.
I also have a SessionLog table. All new...
September 25, 2015 at 4:09 am
(A list of SELECT columns is not needed in the NOT EXISTS - SELECT * or SELECT 1 will do. Originally I think SELECT * in an EXISTS statement was...
September 25, 2015 at 1:06 am
WayneS (9/24/2015)
this won't work... you need the "." between the different parts of the fully qualified name.
O/P has
Set @Dbo= '.dbo.'
but I agree it would be better to have the schema...
September 25, 2015 at 12:53 am
It is raising the question in my mind about "when" we should encrypt.
If we encrypt to-tape then the tape has a chance to compress. If we encrypt to-backup-file that is...
September 25, 2015 at 12:39 am
Luis Cazares (9/24/2015)
But there's nothing strange as the behavior is clearly documented on BOL.
Indeed, I could have phrased it better but it requires that folk have read the DOCs and...
September 25, 2015 at 12:29 am
Vic Rauch-303403 (9/24/2015)
CONVERT(varchar,
I recommend that you don't rely on the default size for varchar, there is some strange behaviour which will catch you out from time to time.
I use (20)...
September 24, 2015 at 2:01 pm
Ed Wagner (9/24/2015)
I prefer the EXISTS approach instead of the OUTER JOIN/IS NULL approach. I think it's much clearer.
I agree, although I've got used to the LEFT OUTER JOIN...
September 24, 2015 at 1:43 pm
erichansen1836 (9/24/2015)
I would not use Table CONTRAINTS (other than INDEXES) because that might interfere with my manual logic to enforce referential integrity in some way?
Fair enough, but I would not...
September 24, 2015 at 1:09 pm
Viewing 15 posts - 241 through 255 (of 476 total)