Viewing 15 posts - 40,741 through 40,755 (of 49,552 total)
robert.larsson (2/26/2009)
Just as i expected but my boss wouldnt take that as an answer =) "keep finding a way to verify if the backup is corrupted or not".
That's what RESTORE...
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
February 26, 2009 at 9:15 am
sqlserverdba.dba (2/26/2009)
Are you refering to Perfmon?
No. Perfmon is a windows tool. I'm referring to SQL Profiler and the stored procs that it uses.
If not then please provide me 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
February 26, 2009 at 9:09 am
Fraggle (2/26/2009)
However, this is not the case. I do get an index seek with INDEX1.
What you're getting is a seek on column1 followed by a filter on...
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
February 26, 2009 at 9:05 am
Fraggle (2/26/2009)
So if I searched by column, 1, 2, 3, & 4, I could essentially create 4 indexes as follows and I should get seeks on all of them?
Yes, 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
February 26, 2009 at 9:03 am
All the info you need is here. http://www.microsoft.com/learning/mcp/certifications.mspx
The self-paced training kits are quite good.
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
February 26, 2009 at 1:42 am
ray.gabriel (2/25/2009)
EXECUTE IMMEDIATE
That doesn't look like T-SQL.
If it is T-SQL, checks are done like this
IF EXISTS (SELECT 1 from sys.objects where name = 'CUSTOMER_RICH_CONTACTS_RO1')
ALTER TABLE MCCOYS.CUSTOMER_RICH_CONTACTS DROP...
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
February 26, 2009 at 1:30 am
1000 page is the usual rule-of-thumb. Smaller than that and the table will probably be in memory. Fragmentation is a disk issue, it doesn't affect pages in memory.
The other thing...
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
February 26, 2009 at 1:27 am
prinztelly (2/25/2009)
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
February 26, 2009 at 1:23 am
This is a forum, not a chat room. Be patient.
On SQL 2000, the only way to get all DDL and DML statements is to use a trace. Not profiler, too...
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
February 26, 2009 at 1:21 am
DDL triggers were introduced in 2005. There's no equivalent feature in SQL 2000
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
February 26, 2009 at 1:16 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic664825-391-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
February 26, 2009 at 1:12 am
Lynn Pettis (2/25/2009)
Someone want to explain what the statistics profile is saying?
Will look in the morning, providing Grant doesn't get it first.
Is 11pm, and I'm dead tired.
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
February 25, 2009 at 1:38 pm
This doesn't look good. Do you have any idea when it started? Do you have a clean backup of this database?
How important is the data in this database? Will losing...
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
February 25, 2009 at 1:37 pm
Couple steps back...
What kind of process do you need to run when a row is inserted?
What's going to be running those processes?
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
February 25, 2009 at 12:45 pm
jblanco (2/25/2009)
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
February 25, 2009 at 11:28 am
Viewing 15 posts - 40,741 through 40,755 (of 49,552 total)