Viewing 15 posts - 8,836 through 8,850 (of 9,253 total)
or just launch the sql2005 installer and select the sample databases option from the install selection!
October 18, 2008 at 5:12 pm
SQLBOT (10/17/2008)
ideal if the drive were striped as opposed to mirrored or RAID-5.
RAID 5 employs striping with parity !!
October 18, 2008 at 5:09 pm
run the traces server side then you'll have no worries 😉
October 18, 2008 at 5:04 pm
LOOKUP_BI (10/17/2008)
I need to schedule a sql trace on Profiler.I see a stop time but no start time.Accordin to msdn I can schedule a Trace by the SQL Profiler GUI...
October 18, 2008 at 5:01 pm
Junior_DBA (10/17/2008)
Guys,please any help???
thanks
i could be wrong and let me know if i'm way off but it sounds to me like you have moved the database to a new server...
October 18, 2008 at 4:51 pm
a 2000 character varchar field is certainly going to allow some undesirable isnt it :discuss:
October 16, 2008 at 12:21 pm
think about it and this is painfully obvious 😉
October 11, 2008 at 3:20 pm
if using a correlated subquery for checkinga condition\item i prefer EXISTS. I've always been under the impression this should be faster than IN. Am i way off base here?
October 11, 2008 at 3:18 pm
dp75 (10/8/2008)
To move a database from 2000 to 2005 you CANNOT detach/attach.
this is only true for the system databases. I use detach and restore all the time. When attaching the...
October 11, 2008 at 4:50 am
out of the 2 i prefer Redgate SQL Backup!
October 11, 2008 at 4:39 am
jjssilva (10/10/2008)
I'm clueless here.
the date and time shown above is 10PM not AM (22:47).
what you are seeing is the installed date and time i believe
October 10, 2008 at 7:25 am
you would have to restore
stuff.mdf
stuff.ldf
then create the extra filegroups\files and move objects from the primary file\group to the new files\groups
October 7, 2008 at 2:07 pm
homebrew01 (10/3/2008)
There are applications that connect using 'sa'.
no application user account should need to connect using 'sa', especially a web user account. Assigning 'sa', this is all too common...
October 7, 2008 at 2:02 pm
SBS comes with SQL server built in
October 7, 2008 at 5:55 am
how are you creating\starting the trace?
is it a server side trace?
October 7, 2008 at 5:46 am
Viewing 15 posts - 8,836 through 8,850 (of 9,253 total)