Viewing 15 posts - 44,176 through 44,190 (of 49,552 total)
Please don't cross post. It just wastes people's time and fragments replies.
No more replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic577330-146-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
September 28, 2008 at 6:08 am
Only the moderators can delete an entire thread. If you do create a new post on an existing issue, please post in the old thread and put the url of...
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
September 28, 2008 at 5:45 am
What does the SQL error log say?
What's you cluster config (how many nodes, how many are active?)
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
September 28, 2008 at 5:42 am
Please run the following and post the output here
DBCC CheckDB(<Database Name> ) WITH NO_INFOMSGS
Do you have any backup that doesn't have corruptions in it?
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
September 28, 2008 at 5:40 am
Have you considered partitioned tables? Depending on what you're inserting it may be possible for you to create a new table, insert into that and then switch that table with...
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
September 27, 2008 at 8:57 am
That means that the backup was striped across two backup files when it was created, and you only have one of those files. Most commonly this happens because when 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
September 27, 2008 at 8:46 am
The form of update that has a from clause is probably what you need.
update table1
set col2 = table2.col2
from table1 inner join table2 on table1.col1 = table2.col1
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
September 27, 2008 at 8:43 am
Stored procedures have no length limit. The max size of a variable on SQL 2000 is 8000 characters (varchar(8000).
You can build the query into multiple variables and exec them...
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
September 27, 2008 at 6:11 am
You could try using a text editor (a good one). Notepad++, ultraedit, etc
You can cycle the error log and SQL will start a new one, then you can read 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
September 27, 2008 at 3:53 am
Does the SQL service account have rights to that directory?
Is anything else using that file (an antivirus, a text editor, etc)
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
September 27, 2008 at 3:52 am
Milu (9/27/2008)
Gila,If i am not wrong, you can't creat an index in Table variable...rite explicitly...rite??
then wht u will do now??/
Only as part of a primary key. That's one of 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
September 27, 2008 at 3:47 am
Can you please post table structure, index definitions, the execution plan (as a .sqlplan file, zipped and attached) and an estimate of the number of rows in the table and...
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
September 27, 2008 at 12:53 am
Are you the administrator? If not, ask your admin to reset password.
If you are the admin, is there a windows authentication login that exists with sysadmin permissions?
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
September 27, 2008 at 12:52 am
Milu (9/27/2008)
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
September 27, 2008 at 12:50 am
Add more disks
Delete unnecessary files.
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
September 26, 2008 at 1:48 pm
Viewing 15 posts - 44,176 through 44,190 (of 49,552 total)