Viewing 15 posts - 18,976 through 18,990 (of 19,560 total)
Here are a couple of articles about indexes
http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx
http://www.sqlservercentral.com/articles/Indexing/68439/
And a previous SSC forum discussion on the topic
http://www.sqlservercentral.com/Forums/Topic604239-146-1.aspx
The forum discussion contains a link to a MS whitepaper on the subject.
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 1, 2009 at 2:55 pm
Simply amazing how quiet the.Thread is today.
One time at band camp...
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 1, 2009 at 2:45 pm
Even with a database with many tables and many columns in each table, the number of changes is limited. Even more limited when considering converting to nchar, nvarchar etc.
I...
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 1, 2009 at 1:06 pm
One more reference for good measure:
http://www.mssqltips.com/tip.asp?tip=1428
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 1, 2009 at 11:45 am
As an alternative, try replacing:
...CAST(mi.sortOrder AS VARCHAR(MAX)), 1
...nh.sortOrder + '/' + CAST(mi2.sortOrder AS VARCHAR(MAX))
with
...cast(row_number() over(order by mi.parentid)...
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 1, 2009 at 11:33 am
The solution would be to change the port number for the named instance.
Microsoft explains it here.
You will only need to change the TCP port.
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 1, 2009 at 11:11 am
Understood.
Those reasons were included in my response.
1. Security Best Practice
2. It should not be an account used by anybody but the service
3. SQL services should not have...
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 1, 2009 at 10:44 am
This should work.
http://technet.microsoft.com/en-us/sysinternals/bb896645.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 1, 2009 at 10:39 am
Microsoft Technet statement:
http://technet.microsoft.com/en-us/library/cc966456.aspx
The account should be one to which no single person knows the entire password. The password should be lengthy. The account should only have the necessary...
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 1, 2009 at 10:29 am
Olympus
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 1, 2009 at 9:46 am
What version of SQL Server are you running?
What have you tried to resolve the issue?
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
November 30, 2009 at 4:45 pm
What is your cluster topology in relation to your network?
Is your cluster within the subnet, cabinet, closet, building, etc? Or is the cluster on a vlan that spans multiple...
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
November 30, 2009 at 4:02 pm
Thanksgiving was good.
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
November 30, 2009 at 4:01 pm
with the limited information provided:
Plan for it with a lot of disk space
Better code control
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
November 30, 2009 at 10:51 am
Grant Fritchey (11/30/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
November 30, 2009 at 10:18 am
Viewing 15 posts - 18,976 through 18,990 (of 19,560 total)