5,248 reputation
11341
bio website billfellows.blogspot.com
location Kansas City, MO
age 39
visits member for 3 years, 4 months
seen 18 hours ago

Developer, devourer of pie, disciple of databases, dictator of datum, drinker of tea, delirious with alliterative devices

@billinkc

SQL Server MVP


Sep
25
comment SSIS Get max value in column and create new column?
Ah, so SourceA would show units sold over time. Source B shows RIGHT NOW. You need to only pull in what was sold for the last date and then pull all the inventory and mash that together where possible
Sep
23
revised Not able to create SSISDB catalog
Linked to Connect with other possible reason for failure
Sep
23
answered Not able to create SSISDB catalog
Sep
23
comment 700 million row mixed text/numeric data - read-only in a single table
Maybe they confused SQL Server with Access
Sep
23
comment Not able to create SSISDB catalog
As noted over on stackoverflow.com/questions/25971803/…, It appears you do not have access to that part of your SQL Server installation (that or the account that is attempting to create it does not have access). Can you confirm/deny this?
Sep
23
comment Friendship and Messages in a MySQL table relational schema problem (concerning big data manipulation)
What is the advantage, in your mind, of using the file system for storing anything?
Sep
23
reviewed Reject and Edit suggested edit on convert string allow null col to int?
Sep
23
revised convert string allow null col to int?
The formatting didn't pick up for the C# after my list
Sep
22
revised SSMS 2014 (and 2012) CTRL+TAB requires pressing enter
Since I was looking up the bindings, figured a screenshot wouldn't hurt the question.
Sep
22
comment not able to create SSISDB catlog in Sql server 2014
It appears you do not have access to that part of your SQL Server installation (that or the account that is attempting to create it does not have access)
Sep
22
comment Alternatives for a LEFT OUTER JOIN query
Have you thought about RIGHT OUTER JOIN...
Sep
21
revised sql server date issue
deleted 1 character in body
Sep
19
answered convert string allow null col to int?
Sep
19
revised convert string allow null col to int?
edited body
Sep
19
comment Backup without using SQL Server Management Studio
Just being obnoxious. ;) I'd have gone sqlcmd route myself but was just pointing out the capability and infatuation with PS many DBAs have
Sep
19
comment Backup without using SQL Server Management Studio
Needs moar PowerShell
Sep
19
revised Backup without using SQL Server Management Studio
deleted 16 characters in body
Sep
18
comment Can't see some stored procedures in sys.procedures
Have you thought about not building html in SQL? Query the metadata tables as you are and use a proper language for string building/html emission?
Sep
16
answered sql server date issue
Sep
16
comment sql server date issue
Is that really the query or have you altered it? I see a RIGHT OUTER JOIN with no join criteria specified