Viewing 15 posts - 44,911 through 44,925 (of 49,552 total)
Perry Whittle (8/21/2008)
GilaMonster (8/20/2008)
You can't do Raid 10 (striped and mirrored) with only two drives. It requires a minimum of 4.Gail i pointed this out already
I thought 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
August 21, 2008 at 6:50 am
Provided the database was shut down cleanly, 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
August 21, 2008 at 6:46 am
The MCTS (technical specialist) certification is a requirement for the MCITP (IT Professional)
You can write the ITP exams without haivng the technical specialist cert, but you won't gain the certification...
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
August 21, 2008 at 6:21 am
Make sure you trace the StoredProcedure:StmtCompleted event and not the StoredProcedure:SPCompleted event.
If you trace the procedure completed, you won't see any inserts/updates within those procedures.
Also trace the T-SQL:Stmt completed 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
August 21, 2008 at 6:20 am
Some background info on what's happened - http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
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
August 21, 2008 at 3:59 am
nikhil.verma (8/20/2008)
Thanks for ur Help!!!!!!!!But i have checked the link and couldnt find suitable info abt my prob .
The entire creation script for that stored proc is in...
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
August 21, 2008 at 3:48 am
823 is an IO error. It means that SQL asked for a page and the OS returned an error. It's a very serious condition and could indicate that you have...
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
August 21, 2008 at 3:41 am
thiyaga4u (8/20/2008)
Default bound to column.
That's not a warning, it's an informational message. Somewhere in your script you're either binding a default to a column (sp_binddefault) or you're using a user-defined...
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
August 21, 2008 at 2:15 am
onlo
How much longer will Microsoft support SQL 7.0 for?Do you have any ideal ?
Mainstream support for SQL 7 ended in 2005. Extended support will end in 2011.
Mainstream support for...
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
August 21, 2008 at 2:09 am
You should always set max memory on a 64 bit server. If you have 3 GB physical memory, set SQL's max to 2GB, no more.
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
August 21, 2008 at 1:55 am
Databases can't be primary. Files can be primary. Each database will (must) have a primary file.
What exactly are you trying to do and what errors are you getting?
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
August 21, 2008 at 1:43 am
DB_Newbie2007 (8/20/2008)
Here is the rest of the post, part of the execution plan:
Any chance you could zip the .showplan file and attach it to your post? It's easier 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
August 20, 2008 at 10:22 am
DB_Newbie2007 (8/20/2008)
Some information:VIEWS are unions of partitioned tables... i.e., VIEW_AllAddresses would be Select * from AllAddresses_Jan08 UNION SELECT * from AllAddresses_Feb08...
First thing that comes to mind... If there's...
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
August 20, 2008 at 10:21 am
Actually, nothing's running the create proc.
When you get the sql text from sys.dm_exec_sql_text and the connection is running a stored procedure, exec_sql_text returns the create statement, rather than 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
August 20, 2008 at 10:06 am
If you did a database copy, then you should have two databases. What do you use to manage them? Enterprise manager? You should see two entries in there for 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
August 20, 2008 at 9:56 am
Viewing 15 posts - 44,911 through 44,925 (of 49,552 total)