Eric M Russell

Forum Replies Created

Viewing 15 posts - 1,621 through 1,635 (of 6,038 total)

RE: Prevent Loading bad data into Table from excel spreadsheet

komal145 - Thursday, March 9, 2017 11:55 AM
We already have stage Table and first we load to stage and then actual DW....

March 9, 2017 at 12:56 pm

#1932600
RE: The Migration Checklist

Does anyone know of a SQL Server schema comparison tool that will script out server level settings, permissions, and objects? From what I've seen, RedGate SQL Compare or Microsoft SQL...

March 9, 2017 at 12:44 pm

#1932597
RE: How to overcome the identity column "jump 1000" issue

ScottPletcher - Thursday, March 9, 2017 11:53 AM
More than 50% of the time, identity is the wrong clustering key, because there's another...

March 9, 2017 at 12:21 pm

#1932585
RE: Database Cattle

That's all well and good, but you best remember to treat your database administrators like pampered pets rather than commodity cattle, or else we'll wander off and get our fur...

March 9, 2017 at 11:57 am

#1932580
RE: How to overcome the identity column "jump 1000" issue

Sean Lange - Thursday, March 9, 2017 10:09 AM
Chris Harshman - Thursday, March 9, 2017 10:00 AM

March 9, 2017 at 11:27 am

#1932571
RE: How to overcome the identity column "jump 1000" issue

alejsek - Thursday, March 9, 2017 7:50 AM
Eric M Russell - Thursday, March 9, 2017 7:10 AM

March 9, 2017 at 9:41 am

#1932542
RE: Approaching Politics in IT

andrew gothard - Tuesday, March 7, 2017 10:22 AM
David.Poole - Monday, February 20, 2017 11:46 AM

March 9, 2017 at 7:26 am

#1932505
RE: How to overcome the identity column "jump 1000" issue

Raymond van Laake - Tuesday, March 7, 2017 2:27 AM
For me it matters that there are gaps.... in our setup the identity...

March 9, 2017 at 7:10 am

#1932499
RE: Whitespace in 3-part name ignored???

My biggest gripe is a database modeled after what was previously a collection of Excel sheets. It makes sense to one person in the accounting department, and is totally useless...

March 8, 2017 at 2:55 pm

#1932416
RE: Whitespace in 3-part name ignored???

ScottPletcher - Wednesday, March 8, 2017 1:32 PM
Eric M Russell - Wednesday, March 8, 2017 1:16 PM

March 8, 2017 at 2:38 pm

#1932410
RE: Whitespace in 3-part name ignored???

I would never name a column 'authorization'. It would be something like 'AuthorizationDate' or 'AuthorizationCode', etc.

March 8, 2017 at 1:16 pm

#1932396
RE: Whitespace in 3-part name ignored???

ScottPletcher - Wednesday, March 8, 2017 10:57 AM
I'll use the best column name for the particular data/business requirement. If that happens to...

March 8, 2017 at 11:52 am

#1932376
RE: Whitespace in 3-part name ignored???

Sadly, this is T-SQL legal too.

March 8, 2017 at 6:55 am

#1932285
RE: Whitespace in 3-part name ignored???

Let's keep this secret to ourselves, lest folks will want to start coding that way.

March 8, 2017 at 5:51 am

#1932264
RE: The Secure Medical Data Challenge

jasona.work - Tuesday, March 7, 2017 10:35 AM
One thing I've picked up from watching various investigative shows (the ones that give the...

March 7, 2017 at 12:52 pm

#1932148

Viewing 15 posts - 1,621 through 1,635 (of 6,038 total)