Viewing 15 posts - 46,876 through 46,890 (of 49,552 total)
GSquared (4/16/2008)
SQL Server Express doesn't include SQL Server Agent. That's one possibility here.
That's what I'm thinking. Though I hope that a 24/7 heavy transaction system is not being run...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 17, 2008 at 12:16 am
chandrachurhghosh (4/16/2008)
we cannot have any non-clustered index if we don't have a clustered index on a table
That's not the case. There's no requirement in SQL server for a table to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 5:37 am
Not that I can see. I jsut ran the installer. I can't see an option to not install the agent. If the database engine is installed, it is automatically installed...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 5:35 am
Pleasure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 5:35 am
Why do you need to reinstall SQL agent? What's the problem?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 3:43 am
Primary key never affects the row order in data pages. It's the clustered index that does that. Now, by default the primary key is a clustered index, but that is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 3:33 am
Are there any triggers on the table?
Switch traceflag 1204 on (DBCC TRACEON (1204,-1)) and the deadlock graph will be written into the error log. That'll give you a lot...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 3:14 am
I believe in SQL 2000, you require sysadmin to use that function, and I don't think there's any way around it.
In SQL 2005, the ALTER TRACE permission was added so...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 3:10 am
The admin tool is Enterprise manager, but as already noted, it's not installed on the server. Are there any DBAs there who might have that installed?
The SQL Scheduler is SQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 3:02 am
MCDBA is SQL 2000. The SQL 2005 certifications are the MCTS (SQL Server 2005) and the MCITP (SQL Server database Admin) and MCITP (SQL Server Database developer)
The link I gave...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 12:59 am
That's correct, but you also will only be able to restore the database using full/diff database backups.
If you take a full backup at 7pm and the next day at 5pm...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 12:38 am
Please don't cross post. It just wastes people's time. Many of the regulars here read all the forums.
No replies to this thread please, direct replies to-
http://www.sqlservercentral.com/Forums/Topic485382-357-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 12:35 am
At this point in time, I would suggest you not consider the MCDBA, unless you have a good reason. The SQL 2000 exams are due to be retired soon.
Consider the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 12:33 am
On that server at that time, no, because the server was clustered and the DAC was set as local only. That has since been changed.
I have tested, and you can...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2008 at 12:32 am
Why do you have a job that shrinks the log file? If you're doing regular log backups, it shouldn't be necessary.
If the database is in simple recovery, the log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 15, 2008 at 2:37 pm
Viewing 15 posts - 46,876 through 46,890 (of 49,552 total)