Viewing 15 posts - 10,411 through 10,425 (of 11,678 total)
anthony.hart (1/18/2011)
I'm trying to import a date with a timestamp into SQL2008 - and it doesn’t work.
What would you recommend for the best format to import as, the format is...
January 18, 2011 at 5:48 am
khushbu (1/18/2011)
not much..I think the SQL governor will govern them with the same set of transaction unless there is explicit BEGIN TRAN defined...
January 18, 2011 at 4:20 am
virender.singh (1/17/2011)
yes, till now its relational database only! thanks :-)for your suggestion.
No problem, glad to help.
Good luck with your studies!
January 18, 2011 at 2:59 am
Another great resource for SSIS tutorials:
(sorry if this seems cynic, but there are tons of good tutorials and articles out there. A little effort won't harm you...)
January 18, 2011 at 2:58 am
Oh yeah, I forgot to mention that the BI tools that ship with SQL Server are FREE (if you use them on the same server as the SQL Server database).
January 18, 2011 at 2:50 am
There is no such thing as A business intelligence.
The question is: can those tools you mentioned be used in a business intelligence solution?
Yes, they can.
My question is: why should you?
You...
January 18, 2011 at 2:48 am
Two statements will results in two transactions, one statement will result in one transaction.
Is there any other reason to make a distinction?
The performance/resource consumption isn't that high, unless you have...
January 18, 2011 at 2:42 am
Excellent article!
It really explains the basics of database design in a fun, not-too-technical manner.
Great job!
And it's been a long time since I've seen Alice and Bob 🙂
(I guess the last...
January 18, 2011 at 1:57 am
stricknyn (1/17/2011)
([Table1] ==...
January 18, 2011 at 1:45 am
Sqlchicken (1/17/2011)
Koen, if you like SSIS make sure you check out the great posts from the previous semesters especially Josef's series from last semester on SSIS. Great stuff!
I will! I...
January 18, 2011 at 1:39 am
jts_2003 (1/17/2011)
Shame that like most useful SQL functionality, online restore of pages requires Enterprise Edition :exclamation:
They must have some reason to sell the more expensive version 🙂
January 18, 2011 at 1:37 am
WayneS (1/17/2011)
January 18, 2011 at 1:36 am
You can't learn how to run with falling from time to time. 😀
Glad you found the solution!
January 17, 2011 at 11:16 am
GilaMonster (1/17/2011)
Koen (da-zero) (1/17/2011)
GilaMonster (1/17/2011)
January 17, 2011 at 11:14 am
Viewing 15 posts - 10,411 through 10,425 (of 11,678 total)