Viewing 15 posts - 45,811 through 45,825 (of 49,571 total)
They are extremely resource intensive. You should not run them when you have users accessin the DB. If you have downtime over a weekend, run the checkdb then
You should (imho)...
July 11, 2008 at 12:15 am
cmille19 (7/10/2008)
One other feature with SQL 2008, which is seldom mentioned is the new multi-server query in SSMS 2008.Works against 2000, 2005, and 2008 servers.
It works to SQL...
July 11, 2008 at 12:08 am
PeterG (7/10/2008)
The database grows every week so it sounds like i don't have to worry about shrinking. Auto shrink is on. Turn it off??
Yes. That's the reason your indexes...
July 10, 2008 at 11:41 pm
ltoso (7/10/2008)
another question poped into my mind, if we rename the sa account will the sa account privileges be transfered for all databases to the new account the we have...
July 10, 2008 at 11:38 pm
Perry Whittle (7/10/2008)
July 10, 2008 at 10:18 am
Jeff Moden (7/9/2008)
Nicely done, Gail... It shows that the Convert method takes about 4 times longer than the DateAdd/DateDiff method...
If I hadn't done a test, you probably would...
July 10, 2008 at 9:37 am
You may be able to get some info from the text file that accompanied the dmp. There's usually a section which contained the input buffer, but there are many cases...
July 10, 2008 at 9:21 am
I suggest you contact Microsoft's customer support services. They can help you with stack dumps.
The mdmp is a mini memory dump. If you have the windows debugger, you can open...
July 10, 2008 at 9:12 am
Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.
No replies to this thread please. direct replies to:
http://www.sqlservercentral.com/Forums/Topic531646-19-1.aspx
July 10, 2008 at 9:10 am
GO is not a T-SQL command. It's understood by client tools only, and signals the end of a batch.
You can't put a GO into a stored procedure, because as soon...
July 10, 2008 at 9:09 am
BAD-DBA-DAB (7/10/2008)
Hi,Copying mdf & ldf is a bad practice.
Why?
July 10, 2008 at 8:58 am
BAD-DBA-DAB (7/10/2008)
Reference:
That's for MSDE (SQL 2000). The Original Poster is using SQL Express (SQL 2005)
ltoso: You can rename the sa account the same way you rename any other account....
July 10, 2008 at 8:57 am
JeeKay (7/10/2008)
July 10, 2008 at 8:55 am
Not from within SQL.
Are you running with mixed authentication mode?
If you are, you can in SQL 2005 disable or rename the sa account. That gives you a little...
July 10, 2008 at 5:03 am
It's not stored anywhere alone that I know of.
I usually query sys.dm_exec_sessions and get the login time of session_id 1. It's the Resource Monitor and it starts when SQL starts...
July 10, 2008 at 4:28 am
Viewing 15 posts - 45,811 through 45,825 (of 49,571 total)