Viewing 15 posts - 3,901 through 3,915 (of 11,676 total)
If you have to compare all columns, just calculate a hash over all those columns and store it alongside in the table. Then you can do your lookup using only...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 1:59 pm
monilps (1/16/2014)
I have to pull all the columns to compare it.
That does not make it a heap. A heap is a table without a clustered index. Doesn't mean one or...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 1:58 pm
monilps (1/16/2014)
It's a heap table..
I don't see why that is relevant?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 1:47 pm
blasto_max (1/16/2014)
Koen Verbeeck (1/16/2014)
Where are you trying to change this? And maybe more important, why?
I want to change the name because I don't like it. I want to change it...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 1:44 pm
sneumersky (1/16/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 1:43 pm
That question is way too broad to be answered in just a few lines.
I suggest you search for some tutorials on SSIS or grab a good book.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 6:46 am
This depends on a whole lot of factors, you're just not giving enough information.
Anyway, an index seek means the index is being used for what is has been build, so...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 6:45 am
madan.kapil-1069442 (1/16/2014)
Thanks David & Phil.. But I was actually looking for a multi-tab csv since I am able to add worksheets/ tabs to a csv file manually.
A csv file is...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 1:14 am
Nice question, but a bit ambiguous.
I can start SQL Server Browser with the command net start sqlbrowser.
No switches there 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 1:07 am
Thanks for the excellent question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 12:58 am
This seems pretty self-explanatory:
Login failed for user 'MyUser'
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 12:57 am
Where are you trying to change this? And maybe more important, why?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 12:57 am
monilps (1/15/2014)
I used a drop down menu, but will try with SQL Statement.Thanks.
If you use the dropdown statement you're going to load the entire table with billion of rows into...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2014 at 2:48 pm
monilps (1/15/2014)
It's very slow... Transferring into the cache
How did you configure it? I hope you wrote a SQL statement and didn't use the dropdown menu to select the table.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2014 at 2:10 pm
Do you have permissions on the output folder? Is the path correct?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2014 at 1:11 pm
Viewing 15 posts - 3,901 through 3,915 (of 11,676 total)