JosiahSiegel

-- http://lassesen.com/msdn/Optimizing_Fill_Factors_for_SQLServer.pdf
SELECT
  '[' + s.name + '].[' + t.name + ']' AS TableName,
  '[' + i.name + ']' AS IndexName,
  SUM(c.Max_length) AS [KeySize],
  CASE
    WHEN SUM(c.Max_length) <= 900 AND
      SUM(c.Max_length) > 848 THEN '97'
    WHEN SUM(c.Max_length) <= 848 AND
      SUM(c.Max_length) > 403 THEN '96'

JosiahSiegel

DECLARE @Table varchar(255) = 'TableName'
DECLARE @Test char(1) = 'N'
DECLARE @FillFactorOverride varchar(3) = NULL
-- SET @Test = 'Y' to only output computed fill factor values. No database modifications will occur.
-- Set @FillFactorOverride to value other than NULL to override computed fill factor value
-- Example: @FillFactorOverride = '90'
-- =================================
DECLARE @CursorTable varchar(255)
DECLARE @MyIndex varchar(255)
DECLARE @MyFillFactor varchar(3)

JosiahSiegel

USE [AdventureWorks]
GO
ALTER USER [Joe] WITH LOGIN = [Joe]
GO

JosiahSiegel

DECLARE @temp_error_log TABLE
(
 date datetime,
 process varchar(50) null,
 text varchar(MAX) null
)

INSERT INTO @temp_error_log
EXEC sp_readerrorlog 0, 1--, 'Login failed' 

JosiahSiegel

SELECT sp.name AS login_name
FROM sys.server_principals sp
JOIN sys.database_principals dp ON (sp.sid = dp.sid)
WHERE dp.name = 'Joe'

JosiahSiegel

DECLARE @temp_error_log TABLE
(
 date datetime,
 process varchar(50) null,
 text varchar(MAX) null
)

INSERT INTO @temp_error_log
EXEC sp_readerrorlog 0, 1, 'Login'

mattantonelli

[user]
  email = [email protected]
  name = That Guy
[push]
  default = matching
[alias]
  tree = log --graph --decorate --pretty=oneline --abbrev-commit
[hub]
  protocol = https
[core]

JosiahSiegel

/*
LOG STORED PROCEDURE RUN TIMES AND ERROR MESSAGES

Example:
====================
-- Place at beginning of your stored procedure
DECLARE @Parameters VARCHAR(200) = NULL;
SET @Parameters = 'Account: ' + ISNULL(@Account,'') + ' UserID: ' + ISNULL(@UserID,'');
DECLARE @StartTime DATETIME = GETDATE();
EXEC Call_ssProcedureLog @ObjectID = @@PROCID, @StartDate = @StartTime, @AdditionalInfo = @Parameters;

JosiahSiegel

DECLARE @spid INT
DECLARE @kill_spid NVARCHAR(100)

DECLARE running_jobs CURSOR FOR

    SELECT 
    req.session_id
    FROM sys.dm_exec_requests req
    LEFT JOIN sys.dm_exec_sessions ses ON ses.session_id = req.session_id
    LEFT JOIN msdb.dbo.sysjobs jobs ON SUBSTRING(ISNULL(ses.[program_name],''),CHARINDEX('0x', ISNULL(ses.[program_name],'')) + 18, 16) = SUBSTRING(REPLACE(ISNULL(jobs.[job_id],''), '-',''),17,16)

JosiahSiegel

REM Required: "-A" for DAC connection. Optional "-E" for trusted connection (instead of "-U -P").
sqlcmd -S 127.0.0.1 -U MyAdmin -P Admin123 -q "exit(DROP TRIGGER [Restrict_Application_Access_Login_Trigger] ON ALL SERVER)" -A