732 reputation
25
bio website
location Arkansas
age 33
visits member for 2 years, 4 months
seen 39 mins 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/…
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
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
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
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?
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/…
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.
Jan
10
comment Remote queries and linked servers
So you're suggesting a RBAR update? Using OLE DB command for UPDATE = RBAR
Dec
19
comment Bulk Data Loading and Transaction Log
Good deal. While the Checkpoint will get the table loaded, getting a minimally logged bulk insert should be a significant performance boost. The TABLOCK should get it done.
Dec
19
comment Bulk Data Loading and Transaction Log
I believe I see the issue. Not sure how I looked this over. The bulk insert isn't using the tablock option. msdn.microsoft.com/en-us/library/ms190422.aspx TABLOCK is the second bullet of the pre-requisites.
Dec
19
comment Bulk Data Loading and Transaction Log
Did you split the procedures up? Which one is popping the log? The bulk insert or the merge?
Dec
12
comment Why is my database stuck in the Restoring state?
Just an fyi, you can check the status of a database restore and get an estimated amount of time for it to complete. Not sure what's actually going on, but would be interested to see what the query results are. The query can be found here: sqldbadiaries.com/2010/09/07/… Just change the where clause from B.COMMAND LIKE '%BACKUP%' to B.COMMAND LIKE '%RESTORE%'
Dec
12
comment Why is this key lookup required?
+1 Good catch @Roji I looked right over that. Still 1216 is well below 10 million so there is still a statistics mismatch. Also, OP stated in the comment that updating stats resolved the issue.
Dec
11
comment Why is this key lookup required?
Have you updated statistics lately? Estimated Number Of Rows is 1 while Actual Number Of Rows is 10,259,536... Dated stats can lead to bad query plans (insufficient memory allocated for joins and sorts, bad join algorithm choices...).
Dec
5
comment error in Execute SQL Task with parameter
What type of connection manager is the database connection defined as? OLEDB? ADO.Net?...