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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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.
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
June 22, 2011 at 2:29 pm
Very cool. Thanks!
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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,...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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!
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
March 2, 2011 at 9:07 am
Viewing 15 posts - 16 through 30 (of 87 total)