Viewing 15 posts - 466 through 480 (of 965 total)
No, you can't move the file while the DB is online. You can add another file to the filegroup, and then shrink the data out of the existing one...
February 10, 2009 at 11:46 am
The easiest way out of this problem is to script the logins from the principle with the SID included and then recreate the logins on the Mirror with the same...
February 10, 2009 at 11:45 am
Yes, and the right ones and how to get index only information is contained in the output of the query I provided above. Did you actually run the query...
February 10, 2009 at 11:41 am
Good to hear it worked out for you.
February 10, 2009 at 11:11 am
We apply all critical OS updates using Patch Authority Plus once a Month, usually on the Thursday after Microsoft sends out its update announcements. At that same time, I...
February 10, 2009 at 10:04 am
Take a look at the output of:
sp_helptext sp_spaceused
It should get you there pretty quickly.
February 10, 2009 at 10:01 am
GilaMonster (2/10/2009)
gupta1282 (2/8/2009)
now I want to start my carrier as a sql server dba.Why do you want to be a DBA? What is it about that career that attracts you?
I...
February 10, 2009 at 9:55 am
If you want to be a DBA and you want really good, worth their weight in gold books that apply to being a DBA. Goto Amazon.com and search for...
February 10, 2009 at 9:13 am
Steve Jones - Editor (2/10/2009)
It mirrors...
February 10, 2009 at 9:09 am
For SQL I would also collect the Batch Requests/sec counter which will give you an idea of how busy SQL is alone. The server could be busy because of...
February 10, 2009 at 9:01 am
Mike,
Make sure that your SQL Service can Lock Pages in Memory. This will keep SQL from being paged out and causing working set trims from OS memory pressure.
http://technet.microsoft.com/en-us/library/ms190730.aspx
This is...
February 10, 2009 at 8:59 am
the__t (2/10/2009)
February 10, 2009 at 8:56 am
The default trace is a good place to start, but it will only have as much information as the number of rollover files which is very short.
http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/
February 10, 2009 at 8:52 am
GilaMonster (2/9/2009)
Gunjan (2/9/2009)
Yes. That's what I have used to consume WCF service.Why?
SQL is a database engine, not an application server. Why is the database calling WCF services?
I can see some...
February 9, 2009 at 1:39 pm
Niels Berglund published a article today on how to consume a WCF Service from SQL CLR.
February 8, 2009 at 6:23 pm
Viewing 15 posts - 466 through 480 (of 965 total)