Viewing 15 posts - 2,356 through 2,370 (of 7,502 total)
jeff.mason (2/7/2011)
ALZDBA (2/7/2011)
jeff.mason (2/7/2011)
...
As for karaoke -- the less said the better. 15 DBAs doing Bohemian Rhapsody was too much.
Your Youtube ref is missing :w00t::hehe::-D
Dear Lord, I HOPE...
February 7, 2011 at 12:48 pm
jeff.mason (2/7/2011)
...
As for karaoke -- the less said the better. 15 DBAs doing Bohemian Rhapsody was too much.
Your Youtube ref is missing :w00t::hehe::-D
February 7, 2011 at 8:11 am
some more info regarding compatibility mode can be found at http://technet.microsoft.com/en-us/library/bb510680.aspx
February 7, 2011 at 6:16 am
yes and yes and it 'll be ok.
mirroring works with log replication, so everything you do on your principal db will also be performed on your mirror db as long...
February 7, 2011 at 6:06 am
just my 2 ct:
Can you check if auto update statistics have been kicked off at the time you experience your issues ?
You have quit a number of indexes and stats,...
February 7, 2011 at 2:50 am
did you check an SSIS solution ?
alternative could be "bcp" import.
I try to avoid the openquery solution
February 6, 2011 at 5:57 am
I fear you cannot do that with sqlserver.
- a primary key is a constraint that enforces uniqueness for the column(s) combination. it is materialized by an actual index. If your...
February 6, 2011 at 5:49 am
With sql2005 auto update statistics is supposed to be better than with previous versions.
That frequent rate of update statistics should no longer be needed, so your issue might be avoided...
February 6, 2011 at 5:38 am
ref: http://support.microsoft.com/kb/955396
I'm not a specialist on install debugging.
Can you check the errorlog file of your sqlserver instance ?
In your posted file I found:
2011-02-05 21:03:09 Slp: Sco: Attempting to check if...
February 6, 2011 at 2:23 am
I think your missing link is a LOGIN created from your certificate.
Keep in mind you should also register the certificate in master db to be able to create a login.
Use...
February 6, 2011 at 1:38 am
SQL2008R2 <> SQL2008 !!
When you attach a db or restore a db, sqlserver checks the systems information level (=system catalog level) and performs the needed updates.
That's the reason you cannot...
February 6, 2011 at 1:07 am
and the big advantage is you have control over the job e.g. at maintenance time disable it or disable the alert.
One word (sentence) of caution:
Keep in mind, when disabling the...
February 5, 2011 at 1:34 pm
Are there any special formats in your xls ?
Why don't you ship a csv file directly from dbmail.
e.g.
declare @subject varchar(1000)
set @subject = @@servername + ': Count of master sysfiles'
EXEC msdb.dbo.sp_send_dbmail...
February 5, 2011 at 1:26 pm
No.
Compat level determines db behaviour (cfr emulation if not the dblevel of the current engine)
Db version can be seen as the db catalog edition. That's different by sqlserver version. (R2...
February 5, 2011 at 1:24 pm
you posted the wrong file !
You can add txt files in the SSC forum itself ( see for the "edit attachements" on the right bottom of your reply page)
You should...
February 5, 2011 at 7:14 am
Viewing 15 posts - 2,356 through 2,370 (of 7,502 total)