Viewing 15 posts - 46 through 60 (of 360 total)
When is the release date?
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
January 3, 2013 at 2:34 pm
Zip file has been attached
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 7, 2012 at 3:18 pm
Thanks for the reply. I can definitely add the clustered indexes on our test database first. But I was assuming that a Clustered Index on GUID column wud cause performance...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 7, 2012 at 3:16 pm
The query execution plan,query and ddl of tables involved in this sql are attached above
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 7, 2012 at 9:20 am
Cadavre (12/7/2012)
Have a read of this article --> http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D, about how to post performance problems.
please find attached the query execution plan,query and ddl of tables involved in this sql.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 7, 2012 at 7:36 am
I already ran this through the tuning wizard and it suggested few indexes and a bunch of statistics with 9% performance improvement
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 6, 2012 at 10:37 pm
Was the service pack1 slipstreamed?
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 6, 2012 at 7:55 am
capnhector (12/3/2012)
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 4, 2012 at 3:00 pm
Is this applicable to SQL Server 2008 R2 on WIndows server 2008 R2?
I am using the SQL Load Generator tool and actually wanted to use some heavy IO queries on...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 3, 2012 at 2:34 pm
CheckDB with repair allow data loss option fixed the errors. My job was able to finish fine now.
USE [master]
GO
ALTER DATABASE [msdb] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [msdb]...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 27, 2012 at 4:03 pm
Thanks everyone for the help.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 20, 2012 at 4:47 pm
No this is not a special table. It has data in there luckily no value less than 50 for the column percentcalled so far.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 19, 2012 at 3:36 pm
I created a stored proc which is as shown below:
USE [DB]
GO
/****** Object: StoredProcedure [dbo].[CheckStatLog] Script Date: 11/19/2012 16:33:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[CheckStatLog]
as
set nocount...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 19, 2012 at 2:39 pm
Thanks for the reply Lowell. The alert is to send out an email if the column value of a table is below a specific number. I have created the job...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 19, 2012 at 1:35 pm
Thanks for your help. It works like a charm
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 19, 2012 at 9:27 am
Viewing 15 posts - 46 through 60 (of 360 total)