Viewing 15 posts - 9,031 through 9,045 (of 9,725 total)
Tom,
It's not the number of disks involved in the RAID per say. It's the way the files are divided.
Think of it this way.
In RAID 1, you have...
January 28, 2008 at 9:34 am
Keep in mind that one data file per CPU does you little good unless you've got separate disk controllers accessing the data. You might notice a difference due to...
January 28, 2008 at 8:59 am
The only security issue I can think of with case sensitivity is Ye Ole Password issue. It depends on whether you want to use case sensitivity on logins.
January 28, 2008 at 8:52 am
Ravi,
It might be the DBA doesn't want to give that kind of access. But just in case the DBA really can't figure it out, tell him/her to grant you...
January 28, 2008 at 7:35 am
Alberto,
Unfortunately, without more details on what you're trying to pull from the table, I can't assist you further. You need to give more details on what you're trying to...
January 28, 2008 at 7:32 am
Yes, there are changes on the DB. Both when you create the index and when you drop it.
Additionally, if you create a clustered index, you're changing the whole structure...
January 28, 2008 at 7:06 am
Intereeestiinnngg.
I'll have to keep this one in mind. Thanks, Grant!
January 28, 2008 at 6:11 am
Grant,
What does the "End = 1" do? I understand the "END" keyword. I'm just trying to figure out the rest of it.
January 28, 2008 at 5:45 am
Are you sure you don't have a typo on the email address in the subscription?
January 28, 2008 at 5:26 am
That explanation doesn't help me figure out how to help you, unfortunately. What information are you trying to check?
Also, if this DB isn't yours, you need to talk to...
January 28, 2008 at 5:20 am
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
Viewing 15 posts - 9,031 through 9,045 (of 9,725 total)