Posts grid page

TempDB Contention
January 21, 2013
WITH Tasks AS ( SELECT session_id , wait_type , wait_duration_ms , blocking_session_id , resource_description Continue reading
Waits
January 17, 2013

http://www.digitalconcourse.com/dropzone/MSCOMM/PASSMN/PASSEVT20090616/Joe%20Sack%20Performance%20Troubleshooting%20with%20Wait%20Stats.pdf http://sqlcat.com/sqlcat/b/top10lists/archive/2007/11/21/top-sql-server-2005-performance-issues-for-oltp-applications.aspx http://technet.microsoft.com/en-us/library/cc966413.aspx

http://selfhandle.com/post/2011/03/26/Where-is-the-bottleneck.aspx

---- Total waits are wait_time_ms<br /> Select signal_wait_time_ms=sum(signal_wait_time_ms)<br /> ,'%signal (cpu) waits' Continue reading
CXPacket Wait Type – Parallelism
January 13, 2013

O que a Microsoft diz sobre CXPacket Wait Type:

Occurs when trying to synchronize the query processor exchange iterator. You may Continue reading

Controling Fragmentation and Page Usage
December 13, 2012

Updating statistics (choose the best one...)

-- EXEC sp_updatestats -- Runs UPDATE STATISTICS against all user-defined and internal tables in the current Continue reading
CHAR, NCHAR, NVARCHAR… Usage and Performance
December 10, 2012

Here are the differences between the datatypes:

Character data types that are either fixed-length, nchar, or variable-length, nvarchar, Unicode data and Continue reading

Top 10 tables in a SQL Server database
November 10, 2012
CREATE TABLE #TableSizes ( TableName VARCHAR(255), TableRows INT, ReservedSpaceKB Continue reading
Microsoft Windows 7 Tuning
March 12, 2012
Command Prompt as Administrator:

Change the timeout on showing boot menu bcdedit /timeout 5 Disable hibernate powercfg -h off Disable services for Windows Search and Continue reading
How to automatically logon to Windows 7
February 12, 2012

Press Windows Key + R and type: netplwiz

At the User Accounts window :

Select the user account that you want Windows to Continue reading