732 reputation
25
bio website
location Arkansas
age 33
visits member for 2 years, 4 months
seen 10 hours ago

Data Warehouse Specialist / Database Developer / Database Administrator


Feb
25
comment Dealing with measure groups of different granularity
Is property type not an attribute of property?
Dec
23
comment Does the recovery model affect query speed?
@MikeFal I wouldn't have made the comment had you not made such a broad statement. I do agree that it's only specific conditions, but good ETL developers can spout them off without hesitation. I've seen a few tweaks to enable minimal logging cut hours off of processing time. Great for ETL and batch processing environments were time is money.
Dec
19
comment Does the recovery model affect query speed?
This answer implies all operations when it should explicitly state it only applies to Updates and Deletes. Inserts will never be minimally logged in the Full recovery model but can be in the Bulk logged or Simple models. technet.microsoft.com/en-us/library/…
Dec
2
awarded  Yearling
Nov
3
answered Query uses Primary Key Index instead of Nonclustered index defined
Oct
28
comment Kerberos Authentication Issue
Ok. Sounds like you're pretty close then. What about the profiler trace. Did you run that? If so, is the NTUsername showing up as correct or anonymous?
Oct
24
answered Kerberos Authentication Issue
Oct
1
comment how to cope with datatype validation errors in ssis 2005
Are the variables by chance 64 bit integers? blogs.msdn.com/b/mattm/archive/2007/04/18/…
Oct
1
comment partitioning by datetime vs date vs int performance
Agreed, I included the bit about the Date dimension.
Sep
30
revised partitioning by datetime vs date vs int performance
Added comment about date dimension for EDW environments
Sep
30
comment partitioning by datetime vs date vs int performance
As for the foreign key, there's really no need for foreign keys on datetimes. The partition function will figure out which HOBT the data should go in.
Sep
30
comment partitioning by datetime vs date vs int performance
For the invalid/missing dates you can just as easily use an irrational value like 0001-01-01 as with int (would probably use 0 or -1 for that).
Sep
30
answered partitioning by datetime vs date vs int performance
Sep
28
comment Production (20GB+) Database running slowly and timing out
@LordRelix - I'd also recommend Mr. Bertrands memory by db and object queries mssqltips.com/sqlservertip/2393/… If the sql server is consuming the max server memory, you could reduce the number of trips to disk (and some of the IO latch) by adjusting the max server memory setting or adding memory. Truthfully, you need a good DBA to review the database, as high IO can be from table scans (missing indexes), non-sargable predicates (bad sql), bad plans (missing indexes, stats out of date), insufficient IOPS, etc.
Aug
6
comment An error was encountered in the transport layer - SSAS 2012 from Excel 2013
If you start a profiler trace on the tabular instance and then and then try to connect via excel, is the NTUsername field your actual NTUsername or Anonymous Logon?
Jul
12
answered What is a good way to replicate code across multiple databases?
May
24
comment Updating a table with millions of records, its been 4 days
"a function on a WHERE predicate" means indexes won't be used". This is not always true. Granted, it's true for this case but sometimes you can get a seek. See Rob Farley's article: msmvps.com/blogs/robfarley/archive/2010/01/22/…
May
4
answered Database stuck in restoring and snapshot unavailable
Jan
10
revised Remote queries and linked servers
deleted 11 characters in body
Jan
10
comment How do I add minutes to a time data type?
+1 @Aaron Alternatively you can convert StartTime and TimeToAdd to datetime and then add. Converting TimeToAdd will be very messy when the minutes are > 59. DATEADD is the best solution.