Viewing 15 posts - 3,601 through 3,615 (of 3,738 total)
Please check out the following Link:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 17, 2010 at 10:36 am
You need a cross table query or pivot predicate which came out in SQL Server 2005.
Try the example provided in the following links:
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=25
http://www.dba-sql-server.com/sql_server_tips/t_super_sql_456_crosstab_queries.htm
http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql
http://www.fmsinc.com/TPapers/access/Reports/monthly/index.html
http://bytes.com/topic/sql-server/answers/144067-crosstab-queries
http://www.sqlservercentral.com/scripts/Miscellaneous/30931/
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 17, 2010 at 8:05 am
Are you running from your client PC or or you remotely connecting to the PC?
Is the Account that you are using a Local Admin on the Server?
Are you running the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 17, 2010 at 3:43 am
I would suggest using a seperate drive(s) for it will increase your performance.
http://msdn.microsoft.com/en-us/library/dd758814.aspx
http://msdn.microsoft.com/en-us/library/dd758814.aspx
http://www.sql-server-performance.com/articles/audit/hardware_bottlenecks_p1.aspx
http://serverfault.com/questions/19866/recommended-disk-partition-setup-for-a-sql-server
http://databases.about.com/od/sqlserver/a/partitioning.htm
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 17, 2010 at 3:33 am
I hope th following links are helpfull:
http://www.dotnetspider.com/SqlServer-Tutorial-158.aspx
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx
http://msdn.microsoft.com/en-us/library/ms345154(SQL.90).aspx
http://www.teratrax.com/articles/sql_server_2005_express.html
Regards,
Welsh
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 17, 2010 at 3:27 am
I subscribe to it & I do not think that it is a waste of Money.
Try to get it during a promotional.
Make sure that you at least subscribe to the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 17, 2010 at 3:18 am
I believe that you hve to enable those Extended SP's via code or the Surface area configuration'
Msg 15281, Level 16, State 1, Procedure xp_findnextmsg, Line 1
SQL Server blocked access to...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 16, 2010 at 1:31 pm
I saw that yesterday but I did not think to ask.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 16, 2010 at 1:15 pm
What is the next problem?
Could you send the Solution and the scripts to create and populate the table(s)?
Are you stepping thru the code, using the immediate window and watch expresions,...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 16, 2010 at 12:21 pm
My apologies, I should have looked it up but I was a little short on time.
In Mucach's Books on VB.NET & C# have some great examples.
But of could you can...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 15, 2010 at 10:12 am
This is the search criteria that I used in Advanced Google Seartc:
How to RESTORE HEADERONLY using SSMS
You can manipulate the abouve search to change the number of hits.
In my opinion,...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 15, 2010 at 6:54 am
Dave Try this Link, I hope that it helps:
http://www.mssqltips.com/tutorial.asp?tutorial=105
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 15, 2010 at 6:49 am
Dave-DJ,
I can only speak for myself not someone else on the foeum but RESTORE HEADERONLY is frequently used by DBA's:
http://msdn.microsoft.com/en-us/library/ms178536.aspx
The SSMS GUI typically for convience or for those tyhat do...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 15, 2010 at 6:31 am
You can use package variables for ech SSIS Package or you could read thru a collection of SQL Servers.
You are using Lightspeed? That has a never nice compression capability.
You...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 14, 2010 at 1:23 pm
Here 2 of the 5 articles by Ross, perhaps if you Google you can find the rest or some additional articles:
http://www.networkworld.com/community/node/30052
http://www.networkworld.com/community/node/30275
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 14, 2010 at 9:49 am
Viewing 15 posts - 3,601 through 3,615 (of 3,738 total)