Skip to main content

Home/ Groups/ MS SQL Server and Analysis Services
Rss Feed
Sort By: Most Recent | Popular Filter: All | Bookmarks | Topics Simple Middle
Sergey Leifer

A closer look at CXPACKET wait type in SQL Server - 0 views

www.mssqltips.com/tip.asp

SQL Server Monitoring

shared by Sergey Leifer on 07 Aug 10 - Cached
  • Sergey Leifer on 31 Aug 10
     
    If you have a server that has more than one CPU core, you may experience high values of CXPACKET wait types. This is typically due to queries that run in parallel and the real issue is to understand how different versions of a query can impact CXPACKET waits...
Sergey Leifer

Automating Analysis Services Deployment - 0 views

Automating build of Analysis Services Projects As you may be aware, an Analysis Services project consists of the following files: A project file (*.dwProj) One or more Data sources (*.ds) One or...

SQL Server Analysis Services

started by Sergey Leifer on 07 Aug 10 no follow-up yet
Sergey Leifer

T-SQL: search by tags - 0 views

DECLARE @filter TABLE (id INT IDENTITY, data nvarchar(32)) insert into @filter (data) values ('sql,performance') insert into @filter (data) values ('profiler') insert into @filter (data) values ...

SQL Server T-SQL

started by Sergey Leifer on 07 Aug 10 no follow-up yet
Sergey Leifer

T-SQL: find SQL TCP port number - 0 views

--SQL 2000/2005 Version set nocount on go DECLARE @SqlPort Nvarchar(10) DECLARE @instance_name Nvarchar(30) DECLARE @reg_key Nvarchar(500) Declare @value_name Nvarchar(20) if left(CAST(SERVERPROP...

SQL Server T-SQL

started by Sergey Leifer on 07 Aug 10 no follow-up yet
‹ Previous 21 - 40 Next ›
Showing 20▼ items per page