SQL Server – Page 4 – LincolnBlog.net

“Why can’t I truncate my log file?!?”

Posted on 03/07/201603/08/2016 by Lincoln Bovee'

I found a VERY useful query from Brent Ozar’s daily emails that go out on how you can check for the reason SQL…

Shrinking TempDB and what to do when it doesn’t

Posted on 02/04/201605/10/2016 by Lincoln Bovee'

This post is based on Tara’s recent blog post over on Brent Ozar’s site: and another: Basically, a query is killing your tempDB.…

Copy Logins to another server with SIDs and passwords

Posted on 02/01/201602/04/2016 by Lincoln Bovee'

I often need to replicate logins to another SQL Server where the SID and password (for SQL login types, not Windows based) need…

Viewing the remaining restore time for rebuilding log-shipping

Posted on 01/25/201601/27/2016 by Lincoln Bovee'

I sometimes need to rebuild the log-shipping for a database and if it is a large database the windows dialogs only display the…

Recycling SQL Server Error Logs without restarting the SQL service

Posted on 01/13/2016 by Lincoln Bovee'

You can recycle the SQL Error Logs without restarting the SQL service by using either of these 2 commands:

USE master;
GO

-- system sproc
EXEC SP_CYCLE_ERRORLOG;

-- or

-- DBCC command
DBCC ERRORLOG;

USE master;

-- system sproc

EXEC SP_CYCLE_ERRORLOG;

-- or

-- DBCC command

DBCC ERRORLOG;

Views – 1965

USE master;
GO

SELECT	name, dbname
	FROM syslogins
	WHERE dbname = 'MyDatabase'
	ORDER BY dbname

SELECT	name AS LoginName, default_database_name
	FROM sys.server_principals
	WHERE default_database_name IS NOT NULL
	ORDER BY default_database_name

USE master;

SELECT name, dbname

FROM syslogins

WHERE dbname = 'MyDatabase'

ORDER BY dbname

SELECT name AS LoginName, default_database_name

FROM sys.server_principals

WHERE default_database_name IS NOT NULL

ORDER BY default_database_name

Views – 2224

SQL Server Page Types Explained

Posted on 11/10/2015 by Lincoln Bovee'

Here is a great blog post explaining the different SQL Server page types and how they work: Understanding Pages and Extents Views –…

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, Linux and PostgreSQL etc…

Category: SQL Server

“Why can’t I truncate my log file?!?”

Shrinking TempDB and what to do when it doesn’t

Copy Logins to another server with SIDs and passwords

Viewing the remaining restore time for rebuilding log-shipping

Recycling SQL Server Error Logs without restarting the SQL service

Switching from SIMPLE to FULL Recovery Model

Devart Studio for SQL Server Issues

Why using GUIDs as Primary Keys on a Clustered Index (Table) is not a good idea and some alternative approaches

Error 4064 Return When User Connects via SSMS

SQL Server Page Types Explained