Viewing 15 posts - 436 through 450 (of 1,825 total)
Does your sqlserver have to be exposed to the internet ?
You could also change the port number it listens on
January 12, 2011 at 1:50 am
First of update the statistics of all tables, but specifically sourcetaggingdataitem.
Its doing a loop join to that table which is causing the problem,
it may be worth forcing a hash or...
January 12, 2011 at 1:39 am
You are comparing chalk and cheese, the processor effort in examining a string to see if it is equal ( your like without a '%' ) is a lot...
January 11, 2011 at 6:17 am
Thats exactly whats happened , if you look at the graphical execution plan you should also see "Actual number of rows = 1" on the "Scan"
January 11, 2011 at 5:41 am
GSquared (1/10/2011)
GilaMonster (1/9/2011)
Craig Farrell (1/9/2011)
If the USA isn't the center of the world, why does it seem like a lot of people keep gravitating to it?
Very bad joke (with bad...
January 10, 2011 at 9:01 am
A rash of slowly changing dimension questions!
http://www.sqlservercentral.com/Forums/Topic605244-148-1.aspx
http://www.sqlservercentral.com/Forums/Topic731253-148-1.aspx
http://www.sqlservercentral.com/Forums/Topic665342-148-1.aspx
Maybe my cynicism level is set to 11 , but are the school's back in 🙂
January 7, 2011 at 3:44 am
Try Todd Mcdermid's Kimball Slowly Changing Dimension
January 7, 2011 at 3:40 am
Brandie Tarvin (1/5/2011)
January 5, 2011 at 7:51 am
What is the exact error message ?
How are you unzipping the files ?
Is it the process of unzipping the file ?
Is it in the processing of the data ?
January 5, 2011 at 7:14 am
There is no internal limit as the the number of loops that can happen in a for loop.
You should be able to confirm this by disabling the inner tasks.
There must...
January 5, 2011 at 6:21 am
kurniawan.kumala (1/4/2011)
finaly i found the script to solve my case. Thank's
Glad to hear that.
Just make sure you understand the code fully, before you implement it.
After all , you will...
January 5, 2011 at 1:33 am
Jeff Moden (1/4/2011)
On the first one, click on the "Report Abuse" button, select the radio button with the CopyRight indication, and follow the appropriate link to report the infringment to...
January 5, 2011 at 1:31 am
WayneS (1/4/2011)
Dave Ballantyne (1/4/2011)
Do you even know what bit shift is ?No... should I?
Rhetorical question 😉 , but a bit shift involves moving all the bits in a byte (to...
January 5, 2011 at 1:29 am
Viewing 15 posts - 436 through 450 (of 1,825 total)