Viewing 15 posts - 18,946 through 18,960 (of 19,560 total)
I haven't used TSM for SQL 2005, so my recommendations would be as follows:
1. Install TSM on a server with SQL 2005
or
2. Install SQL 2005 management tools on...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 4:53 pm
Technet Article:
http://msdn.microsoft.com/en-us/library/ms143799.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 4:37 pm
Something that works for some environments is to have a table where they have write permission. This table would hold job data. In this table they can submit...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 4:35 pm
Yesterday while the tivoli backups were running on my SQL Databases, i noticed that out of 30 GB memory that is allocated through AWE, one of the clustered indexes on...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 4:25 pm
The suggestion that Curtis gave about the CurrentID and Top N rows is essentially the same sort of configuration we have done. It works surprisingly fast for what it...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 4:12 pm
SQLbee (12/1/2009)
I am looking to do some administration on a 2 node cluster based on Windows server 2003 Enterprise and SQL 2K5.
I have a few services that are...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 4:09 pm
And I will give my vote to RedGate SQL Compare for schema and objects, and RedGate Data Compare for comparing the data in tables.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 3:46 pm
Here is a bare bones skeleton script. If you modify it, you should be able to accomplish your goals.
WITH dedupeCTE (COl1,Col2, DuplicateCount)
AS
(
SELECT COl1,Col2,
ROW_NUMBER() OVER(PARTITION BY COl1,Col2 ORDER BY Col1)...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 3:43 pm
Kabaari,
Lynn has put it very well and Lowell has helped tremendously with little to go on. There are many people in this forum ready to help, if they can...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 3:25 pm
GilaMonster (12/2/2009)
CirquedeSQLeil (12/2/2009)
just came across this ad:http://www.sqlservercentral.com/Forums/Topic716821-360-3.aspx
You missed what happened over Thanksgiving weekend. On the friday that guy had posted to over 20 threads with exactly the same message, even...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 3:17 pm
CALs do not control the number of concurrent queries. The CAL "controls" the number of Concurrent Clients. A CAL is associated with a server or desktop.
If you are...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 2:44 pm
A couple more resources with step by steps:
http://wiki.cdyne.com/wiki/index.php?title=Mirroring_SQL_Server_2005
Servers not in a domain (workgroup model as an example)
http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx
Can you telnet to the Fully Qualified Domain Name of the Mirror partner on...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 2:40 pm
jez.lisle (12/2/2009)
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:1474
Date:02/12/2009
Time:21:24:21
User:N/A
Computer:MyServerName
Description:
Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 2:32 pm
jez.lisle (12/2/2009)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 2:30 pm
just came across this ad:
http://www.sqlservercentral.com/Forums/Topic716821-360-3.aspx
Last post in the thread
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 1:49 pm
Viewing 15 posts - 18,946 through 18,960 (of 19,560 total)