JN,I did that as an example, for the real deal you to get the data from tmp_listing not from Propmaster like it was on the example if you use:FROM tmp_Listings B Where NOT EXISTS ( Select * FROM PropMaster A Where B.LSID = A.ListingID )ORFROM tmp_Listings B Where B.LSID NOT IN ( Select ListingID FROM PropMaster) you are not going to get […]
2005-02-17
I stopped SQL, deleted the files, restarted SQL. The new tempdb was created at 15GB (completely empty) and it still won't shrink via EM or QA.
2005-02-17
I looked through some stats I keep and came up with a number (based on 3 fact tables 20 columns/12 million rows and a couple dim tables) =5.75 GB.Don't forget Growth % and db bkp file space.200GB would be plenty. I wouldn't under sell myself on space. Seems like dw projects grow as the audience […]
2005-02-17
I have been doing it for the past two years using the method described by Phil. It's fast and very effecient. Just remember to either truncate the loader table first (I actually run a truncate before and after the loads just in case) Marvin
2005-02-17
Hi there,We ran across the same situation - wanting to record use of a stored procedure, including its final status. Originally, we just added a line to the stored procedure that recorded its own execution in a log table, but that failed if the transaction rolled back for anything.Now we have a "header" procedure that […]
2005-02-17
My Linked Server name and sql query change. Even if I write multiple queries to fulfill all the conditions, I am still left with the linked server name as a variable?The latest thing is to use four-part name. Can I supply variables to do that job?We do not want the server locations to be hard […]
2005-02-16
Thanks for hints. I found the example. It's a lot more invovled than I expected - but I will work through it.
2005-02-15
If you are concerned about NULLS for your variable, you can also do this: SET @sql = 'SELECT TOP ' + IsNull(str(@number),'100 PERCENT') + ' * FROM table_name'
2005-02-15
Frank - I understand. We are planning another addition to our family and I share the household duties. The wife works (sometimes longer hours than I do). I, too, have the stories - Cinderella and Snow White are big, my favorite Alice was kind of a dud.
2005-02-14
See if this helps:http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx
2005-02-14
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers