Viewing 15 posts - 211 through 225 (of 449 total)
I think the poster just "clicked" on the PK button to create the original PK and by defualt it's created as a clustered index. That would account for the...
November 20, 2009 at 7:19 am
Excellent point, although I believe you get an error like "incompatible OS for this version".
November 5, 2009 at 7:51 am
You're positive you selected the "Database Engine" during the install? If so, try installing again. If you already have an instance installed you will have the "named instance"...
November 4, 2009 at 6:24 am
I'm using Red Gate SQL Backup a 3rd party tool and the entries written to my "backupmediaset" are "Microsoft SQL Server".
Maybe because I'm running it as a SQL Server job...
October 30, 2009 at 12:42 pm
Bru,
Very true.
I guess our work is complete.
October 30, 2009 at 7:26 am
If you have an idea as to when this might be running, you can always set up a server side trace. To reduce the trace, you can filter on...
October 30, 2009 at 6:27 am
Bru Medishetty (10/29/2009)
These Forums are not for fun to try the untried or finding the most rarest feets. These Forums are for problem solving and I would as always work...
October 30, 2009 at 5:57 am
"You could right click and open the table using Management Studio. Click in upper most left hand corner to highlight all records and right click copy. You would then open...
October 29, 2009 at 12:34 pm
Scripts are always used, at least behind the scense. SSMS, SSIS, Import/Export, Red Gate SQL Compare/Data compare, etc...
That's how interaction with databases work using DDL and DML.
October 28, 2009 at 6:08 am
Yes, both users can alter each other's objects in the same database, using DDL; but not through SSMS.
Let me clarify more. The user(s) will not be able to use...
October 23, 2009 at 7:14 am
SQLIOSIM if you're going to test the disk subsystem and IO patterns, as well.
October 14, 2009 at 7:59 am
You would get a deadlock if both queries occured at the exact same time.
Table hints will allow you to perform a dirty read. READUNCOMMITTED
September 18, 2009 at 8:37 am
So Steve, it sounds like you use mixed mode if you're using a DAL. Why are you using a SQL Login at the DAL layer? Is it because...
September 18, 2009 at 6:53 am
Make sure you update the stats after the restore/upgrade.
September 14, 2009 at 7:34 am
Yes. You'll want to check: tools--options--sql server object explorer--scripting
Make sure you're scripting the index's and keys.
September 4, 2009 at 9:41 am
Viewing 15 posts - 211 through 225 (of 449 total)