I recently (2 weeks ago) took a class from my friend Kalen Delaney on SQL Server Internals.  It was 5 days and she really packed the material in there.  I really like in depth training because it makes me think harder and I excel faster for some reason in my learning.  Well I have always found that conferences and training classes ...

I am a bit new at sql server and am trying to resolve a coding issue that I have come across. I hope there is someone out there that might be able to assist me. I am working with zip code +4 data and am trying to range the data to reduce the size of the database from the current ~65 million lines of data.  The trick is that I need to range ...

If your data has a small percentage of duplicates, then IGNORE_DUP_KEY may speed up your inserts. For larger amounts of duplicates, IGNORE_DUP_KEY may slow them down significantly. I set up two tables, stripping down all the irrelevant details, as follows:   CREATE TABLE t1(n INT NOT NULL PRIMARY KEY) GO CREATE TABLE ...

Suddenly seeing a brand new error connecting to SQL 2000 cubes in a single OLAP database - the other databases don't throw the error.  Searches online have turned up nothing.  From Excel, the messages looks like this: ''Excel was unable to get necessary information about this cube.  The cube might have been reorganized or changed ...

Thanks for the example and for attempting to answer my question, I've been posting it all over the place and have had minimal response, granted it's a small bit of business in Sql Server. My question might have been a bit vague, I'd hoped that by keeping it simple it might spark more conversation. So, to refine the issue using your example ...

I'm working with typed xml in Sql server '05 and haven't been able to resolve a couple questions through the documentation or any of my searches so far - so fanfare aside here is the most immediate question: If I have an XML Schema Collection with multiple namespaces how can I specify an xml column or variable that only targets one of ...

So finally I have something to announce!   Myself and a bunch of friends have been working on Less Than Dot for a while now. The site has a forum, blogs and a wiki. More info why we started Less Than Dot and who we are can be found here: http://www.lessthandot.com/aboutus.php Since I am mostly a SQL guy, I wrote a collection ...

Hi All,    Following is the secnario,                  I have two tables one is dimension table and other is hierarchy table, which contains the following type of data Dimension Table MemberID ...

Hello guys, I have to write business solution for shortterm and new term. Scenario like this. There are two companies one is in JAPAN and other one is in UK they both making bikes. Now they merger togather, CEO is asking  the HRM department to have data of employees. Now company 1 is having won XP workstation with IBM DB2 ...

I am not a SQL developer by any means. I have a application to build for a Valet company that will require a laptop on site with no internet connectivity to function locally. There will be about 15 locations that all operate independently. After the day is done, the laptops will connect to the internet and upload all data to a hosted SQL server on ...