Viewing 15 posts - 7,411 through 7,425 (of 9,707 total)
sturner (9/8/2010)
If the database is empty just script it out and all the objects/users and permissions and run the scripts in production.
Even if the database isn't empty, you can still...
September 22, 2010 at 6:20 am
Grant Fritchey (9/22/2010)
...I think people thought I was a little weirder than usual.
I'm so glad you put those last two words on that sentence. Otherwise, I would feel the need...
September 22, 2010 at 6:17 am
cashmanifesto (9/16/2010)
September 22, 2010 at 6:16 am
There is no such thing as Incremental backups either. However, you could send Iron Mountain Differential backups, which is a list of all changes since the last FULL backup. Or...
September 22, 2010 at 6:14 am
Back on topic. Some questions on this site aren't necessarily bad. They're just terrifying.
http://www.sqlservercentral.com/Forums/Topic986504-1292-1.aspx?Update=1
September 22, 2010 at 6:07 am
It is my experience that Project Managers neither care, nor need to care, about creating new databases. They should hand you project specs with just enough functionality (formulas, etc.) that...
September 22, 2010 at 6:05 am
Wow. That's quite a chunk of code you've put up.
Quick question. Why do you want to use triggers? I'm not sure about how it works in SQL 2k8, but in...
September 22, 2010 at 5:53 am
GilaMonster (9/22/2010)
Ran across this earlier, thought it appropriate.
That is hilarious!
September 22, 2010 at 5:49 am
Alvin Ramard (9/21/2010)
A query walks into a bar, sees two tables and says: "May I join you?" 😀
GROAN!
September 22, 2010 at 5:45 am
Okay, I'm going to ask again. What service pack (and version) of SQL Server are you running?
EDIT: And how much RAM are you running on the machine you're working from?...
September 22, 2010 at 5:37 am
jspatz (9/21/2010)
September 22, 2010 at 5:36 am
fenwicc (9/21/2010)
check your cluster configuration. The security on the file share needs to be set up using the cluster administration tool.
If this is NOT what you checked when you...
September 22, 2010 at 5:35 am
Query tuning depends a lot on your database structure and the types of queries you're using. If you want generic advice, check out Books Online and pretty much every book...
September 21, 2010 at 10:25 am
CirquedeSQLeil (9/21/2010)
d.qureshi (9/21/2010)
Thank you for your kind advice.
So there is no way to move a table and its data from one physical disk location to different physical disk location...
September 21, 2010 at 10:18 am
Viewing 15 posts - 7,411 through 7,425 (of 9,707 total)