Viewing 15 posts - 9,031 through 9,045 (of 9,715 total)
Look up books written by the Kimball Group for a start. This has been an excellent reference for me.
Also, look into books about database design. Most...
January 28, 2008 at 5:12 am
It's not a question of which is better in general. It's a question of which is better for your particular circumstances.
Or in common DBA parlance, "It Depends." @=)
What language(s)...
January 28, 2008 at 5:09 am
What are you trying to achieve with this temporary index? And why do you want it to only be temporary?
January 28, 2008 at 5:05 am
And look up "JOIN" in Books Online. That should help you figure it out.
January 28, 2008 at 4:53 am
It's not about the size of the database. It's usually about the number of physical disks you have (or SAN LUNs) available.
Splitting a DB into multiple files...
January 28, 2008 at 4:44 am
There's no comprehensive list, but ISTR that I had to change compatibility before I could use PIVOT / UNPIVOT.
I can't tell for sure now because all the DBs...
January 28, 2008 at 4:37 am
I go with Ian's suggestion. I always try various combinations then run through a Query Execution plan to see which one works best for my current needs. I...
January 28, 2008 at 4:32 am
Are you talking user databases or System databases?
Because System Databases cannot be detached while SQL Server Service is running. You'll have to use the Alter Database command...
January 28, 2008 at 4:29 am
There are all sorts of books and training materials out there. Some of the stuff for certification exams can also be useful for learning the basics of SQL Server.
First...
January 28, 2008 at 4:26 am
And if there are error messages, don't forget to include them in your post.
January 28, 2008 at 4:10 am
I've stopped using NOLOCK just because of the drawbacks. I want to see all the data, so I'll take a little bit of a performance hit just to make...
January 28, 2008 at 3:54 am
Glad you found it. Thanks for posting the solution!
January 28, 2008 at 3:53 am
ToString() would certainly return the values but you can't SUM() a string. So I would still have to do an additional conversion to get the money or smallmoney values...
January 28, 2008 at 3:52 am
It's the Microsoft Self-Paced Training Kit for 70-441. I don't have it on me at the moment (it's at work), but the cover is blue and it has a...
January 25, 2008 at 3:32 pm
Viewing 15 posts - 9,031 through 9,045 (of 9,715 total)