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

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

@billinkc

SQL Server MVP


Oct
6
comment Why does SSAS keep restarting every few seconds?
Did the OS get patched or anything? Might be worth a support call to MS if it's a prod instance
Oct
6
comment Should these two indexes suggested by the SSMS missing index feature be combined?
Until the smarter ones comment/answer... The first index satisfies queries that look up based on IsSynchronized. The second looks up based on PackageID. You would need to rework your query to have one of those as part of the index. e.g. SELECT PE.PackageID FROM dbo.PackageEvents PE WHERE PE.IsSynchronized = 1 SELECT PE.EventDate FROM dbo.PackageEvents PE WHERE PE.IsSynchronized = 1 and PE.PackageId = 'x'` but I don't know whether your going to be able to always know the available IsSynchronized values for idx (IsSyn, PkgId). Suppose since it's binary, could UNION ALL the 1 & 0 version
Oct
6
comment Looking for a snippet illustrating ambiguous result of a join in a where clause
sqlskills.com/blogs/conor/…
Oct
3
comment Package performs differently on two different instances on the same server
I'm inclined to believe you're waiting on the data to land in the destination table. Perhaps there is activity going on which is keeping the package from locking the target table. They could also be doing lots of dumb things so try posting a screenshot of the Control Flow and your data flows. Between the destination and the penultimate component, double click on the connector line and get a screenshot of your MetaData tab. Finally, double click the destination and give us a peek into that. Punch all that into the question if you would
Oct
3
answered Permission to view execution report in SSIS Catalog
Sep
30
awarded  Explainer
Sep
30
answered Getting information on users payments via subscriptions
Sep
30
comment Database design for an online babyShop ,Toy shop
en.wikipedia.org/wiki/Junction_table
Sep
30
comment Will increased network latency cause table locks in MS SQL Server?
And even with nolock, you'll still get locks
Sep
30
comment Database design for an online babyShop ,Toy shop
I think about Amazon. There if I'm buying Tea it might show up in "Grocery & Gourmet Food" or it might show up in "Home & Kitchen". Do you really think your customer wants to lose sales because a box of Lego is categorized as a "Boy" toy? I would think not. Therefore, I would think a Product could have multiple categories
Sep
30
comment Database design for an online babyShop ,Toy shop
You do not want to call a table Order unless you really want to escape the name every time you reference it
Sep
29
revised SSIS Get max value in column and create new column?
added 1206 characters in body
Sep
29
comment SSIS Get max value in column and create new column?
Providing specifics in your questions can never hurt the supplied answers.
Sep
29
answered SSIS Load using SQL Command
Sep
26
revised How I convert it to SQL Server please
added 190 characters in body
Sep
25
comment SSIS Get max value in column and create new column?
@GlenSwan Help me understand the concern. How will a poisonous record in A pooch the results?
Sep
25
revised SSIS Get max value in column and create new column?
added 2855 characters in body
Sep
25
answered SSIS Get max value in column and create new column?
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