Viewing 15 posts - 16 through 30 (of 87 total)
I like centralized. For me it makes maintenance easier. If I want to update a specific script, etc, I only have to change it in one place. Also DR is...
July 8, 2011 at 8:59 am
I don't see an update statement in your MERGE.
Not sure about how to handle NULLS. My whole warehouse is NOT NULL.
June 23, 2011 at 9:15 am
Probably won't work because what if your key's don't match? I would imagine they won't all be the same key, so you'll then end the time period for every row...
June 22, 2011 at 2:29 pm
Very cool. Thanks!
June 22, 2011 at 9:43 am
I have heard from more than one person that all columns in the clustered index also show up in each non-clustered index on that same table, which is why you...
June 22, 2011 at 9:08 am
Actually you can do both. Put all the fields you wish to carry history on in the ON clause for matching. This will tell the MERGE you want a new...
June 21, 2011 at 12:17 pm
In my experience, you should always stage your data on the local server before doing any manipulation and / or merging. So for dawalker, extract new information in native form...
June 20, 2011 at 9:01 am
Her machine is due for a refresh in 2 months, so her hardware performance has been a problem for awhile. Also, I just spoke with one of our network guys,...
May 19, 2011 at 5:20 pm
Well it looked as though her firewall was not on at all, but we have corporate Semantec running our client firewalls. So as not to let anything go untested, I...
May 19, 2011 at 5:08 pm
opc.three (5/19/2011)
amenjonathan (5/19/2011)
Stuff1. Is the SQL Browser service running on the server?
2. Can the user reach the server on port 1434 UDP? You can check this using PortQryV2
1. The browser...
May 19, 2011 at 4:31 pm
She's connecting via Windows Authentication. She can connect via IP, so I didn't figure it was a permissions issue. She's currently working in SSMS by connecting via IP, but I...
May 19, 2011 at 4:27 pm
This kind of discussion comes up a lot. Who should know what. I like to think of the IT industry as a young medical industry. Sure at first everyone did...
May 2, 2011 at 11:08 am
belgarion (3/24/2011)
Agree with all the comments about using smallish batch sizes to keep row level locks from escalating! Also, if the delete(s) involve hash matching, keeping to...
March 24, 2011 at 4:06 pm
Just about to cube a new warehouse, so this couldn't have come at a better time! Thanks!
March 3, 2011 at 9:28 am
Some experience at my prior employer lends me to believe they may have thought you weren't planning on staying? My last employer hired two very overqualified people to fill a...
March 2, 2011 at 9:07 am
Viewing 15 posts - 16 through 30 (of 87 total)