Group items tagged
Input Note - 0 views
set nocount on declare @SqlInstanceName varchar(128), @SqlServiceName varchar(128), @Cmd varchar(8000), @TempDbLoc varchar(255), @SysDbLoc varchar(255), @UserDbDataLoc varchar(255), @U...
A closer look at CXPACKET wait type in SQL Server - 0 views
-
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...
SQLDiag for SQL Server 2005 - 0 views
-
This article explains how to use SQLDiag as a Service to get more thorough diagnostics than the standard Profiler traces or Server Side Tracing...
T-SQL: list files in folder - 1 views
create table #Files ( FullName nvarchar(255) null ) insert #Files exec master..xp_cmdshell 'DIR C:*.csv /B /S' select right(FullName, patindex('%%', reverse(FullName)) - 1) as ShortFileName ...
T-SQL: disk free space alert - 0 views
USE [msdb] GO EXEC msdb.dbo.sp_add_alert @name=N'Disk Free Space on Drive E', @message_id=0, @severity=0, @enabled=1, @delay_between_responses=0, @include_event_description_in=0, ...
T-SQL: last day of the month, round dates - 0 views
SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,GETDATE())),DATEADD(m,1,GETDATE())))
Error Handling in SQL - 0 views
T-SQL: disk free space alert - 0 views
How to Find Corrupt Records of The Pages - 1 views
-
Say one of the pages in your table is corrupt and while repairing the corrupt pages, you may eventually end up loosing some data. You may want to find out which records are on the page.
SQL Server Programming Hacks - 0 views
Simple vs Searched CASE statements-SSAS - 0 views
-
Simple vs Searched CASE statements
Today's Annoyingly-Unwieldy Term: "Intra-Query Parallel Thread Deadlocks" - Bart Duncan... - 1 views
-
Today's Annoyingly-Unwieldy Term: "Intra-Query Parallel Thread Deadlocks"
‹ Previous
21 - 40 of 63
Next ›
Last »
Showing 20▼ items per page