Viewing 15 posts - 8,416 through 8,430 (of 11,676 total)
Thanks for this nice basic question!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 21, 2011 at 12:57 am
Put an expression on that variable you mentioned and use those two date variables there. Make sure you convert those dates to string if you want to include them in...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 21, 2011 at 12:56 am
Triality (12/20/2011)
Haha, I forgot to map the new derived column to the table column. Looks like that method did work!
I think that implicit conversion also works. If you insert...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 21, 2011 at 12:54 am
Oh yeah, I forgot:
a few years ago, the SharePoint team published a white paper with "advice" on how to administer those databases. It was full of bad practices and the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 21, 2011 at 12:52 am
I don't know a lot of SharePoint databases (lucky me!), but I know the following:
* they are fond of using GUIDS (bleh)
* they have very cryptic names for their databases
*...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 21, 2011 at 12:51 am
According to MSDN, indexes are not transferred:
"Indexes, constraints, and triggers defined in the source table are not transferred to the new table, nor can they be specified in the SELECT...INTO...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 21, 2011 at 12:48 am
Coolroof (12/21/2011)
I want Change windows authendication user to sql server windows authentication user..because that user is main user. this user only create db and maintenace plan and jobs.pls steps
What is...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 21, 2011 at 12:45 am
Dev (12/20/2011)
Koen Verbeeck (12/20/2011)
Dev (12/20/2011)
... the psychologist use ink blot cards (Rorschach test) to read the minds.
I'm not locked in here with you! You're locked in...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 20, 2011 at 11:56 pm
Dev (12/20/2011)
... the psychologist use ink blot cards (Rorschach test) to read the minds.
I'm not locked in here with you! You're locked in here with me!
Ahem...
10 bonus points...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 20, 2011 at 11:43 pm
Greg J (12/20/2011)
fast-load... never saw it have such a dramatic effect.
It's because it does it inserts in bulk mode, while the regular mode does it inserts row by row (yup,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 20, 2011 at 11:37 pm
There is no easy answer for that.
It depends on those user defined functions: how complex are they, can they be translated into SSIS or not et cetera. You can call...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 20, 2011 at 6:01 am
Charmer (12/20/2011)
i have column name CrossStreets in an excel sheet which will be having datas like "W MENOMONEE RIVER PKWY"....
i need to split the records into 3 columns...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 20, 2011 at 5:43 am
ramyours2003 (12/20/2011)
thanks for sending i want all the databases in percentage growth instead of getting one db result .
What have you done so far?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 20, 2011 at 5:19 am
Henrico Bekker (12/20/2011)
I am not a very fast reader as it would take too long to read a book.
Absolutely zero and no offence to Koen, but being able...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 20, 2011 at 1:48 am
forsqlserver (12/20/2011)
Thanx Koen,But I just want to be precise and solid confirmation.
Actually, then you should check MSDN (or the F1 page), or call Microsoft support.
I can tell whatever I want...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 20, 2011 at 1:44 am
Viewing 15 posts - 8,416 through 8,430 (of 11,676 total)