SQL Server – Page 7 – LincolnBlog.net

SQL Server coding and naming conventions and best practices and guidelines

Posted on 05/30/2014 by Lincoln Bovee'

Here is a good blog post on SQL Server coding and naming conventions: Database coding conventions, best practices, programming guidelines Views – 3003

Finding Deprecated Command Usage via Traces and Extended Events

Posted on 05/30/201401/21/2019 by Lincoln Bovee'

Below is my posting on dealing with upgrading your SQL Server to either 2012 or 2014 and having to deal with databases that…

Reseeding and Updating the INDENT_CURRENT Value in SQL Server

Posted on 05/09/201412/06/2016 by Lincoln Bovee'

This code will do the following: 1. Display the current INDENT_CURRENT value for the identity column for the specified table. This value should…

Syncing SQL logins and database user accounts across servers with SIDs

Posted on 04/22/201401/21/2019 by Lincoln Bovee'

Here is a good article on syncing SQL logins across servers with the same SIDS to log-shipped databases will propagate the correct access…

How to take a database offline

Posted on 04/21/201404/21/2014 by Lincoln Bovee'

Here is one way to take a database offline. This will prevent any reads, writes or even a connection to it (including any…

DBCC command list

Posted on 04/01/2014 by Lincoln Bovee'

DBCC activecursors [(spid)] DBCC addextendedproc (function_name, dll_name) DBCC addinstance (objectname, instancename) DBCC adduserobject (name) DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid)…

Using the undocumented command fn_dblog to view the SQL log

Posted on 04/01/201401/21/2019 by Lincoln Bovee'

Reading the SQL Server Log file – and undocumented command

SELECT
[Current LSN],
[Operation],
[Transaction ID],
[Parent Transaction ID],
[Begin Time],
[Transaction Name],
[Transaction SID],
[Lock Information],
[Description]
FROM fn_dblog(NULL, NULL)
WHERE [Operation] IN ('LOP_BEGIN_XACT', 'LOP_COMMIT_XACT', 'LOP_MODIFY_ROW', 'LOP_DELETE_ROWS', 'LOB_INSERT_ROWS')

SELECT

[Current LSN],

[Operation],

[Transaction ID],

[Parent Transaction ID],

[Begin Time],

[Transaction Name],

[Transaction SID],

[Lock Information],

[Description]

FROM fn_dblog(NULL, NULL)

WHERE [Operation] IN ('LOP_BEGIN_XACT', 'LOP_COMMIT_XACT', 'LOP_MODIFY_ROW', 'LOP_DELETE_ROWS', 'LOB_INSERT_ROWS')

to get all the column, execute this:

SELECT TOP 100 *
FROM fn_dblog(NULL, NULL)
ORDER BY [Current LSN] DESC

SELECT TOP 100 *

FROM fn_dblog(NULL, NULL)

ORDER BY [Current LSN] DESC

Here is a blog…

LincolnBlog.net

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

Category: SQL Server