SQL Server Education (by the geeks, for the geeks)
SQL Server Accidental/Involuntary/Junior DBAs Series
Many a times need arises to find all objects table depends on or is being referred. This blog will help you to find dependencies of a table in SQL Server. This …
Find dependencies of a table in SQL Server Read MoreStart SQL Server in single user mode command prompt is a must know task for any SQL server DBA. This can be either done via GUI by setting the startup parameters for …
Start SQL Server in single user mode command prompt Read MoreHere is quick query to find stored procedure related to column in database. This comes handy when you have to alter/remove a particular column from a table and you need to …
Find stored procedure related to column in database in SQL Server Read MoreMany a times need arises to find all stored procedures related to a table in the database. The below queries come handy then. — Query 1 SELECT DISTINCT objects.name, objects.type, comments.text …
Find stored procedure related to table in database in SQL Server Read MoreEvery now and then questions come up forums asking about how to truncate log file in SQL Server. Truncating a transaction log file means clearing out space in the log file. …
Truncate log file in SQL Server Read MoreHere is quick SQL function to convert list to table. — sql function to convert list to table CREATE FUNCTION fn_listtotable ( @list nvarchar(max), @delimeter nvarchar(100) ) RETURNS @split TABLE ( …
SQL function – convert list to table Read MoreMany a times need arises to create comma delimited list in SQL Server. This can be done using the DOR XML PATH feature of SQL Server. The FOR XML PATH generates …
Create comma delimited list in SQL Server Read MoreRe indexing database tables in SQL server is a very wide topic. Ideally, we have database maintenance tasks scheduled to run during maintenance window to rebuild indexes along with other maintenance …
Re indexing database tables in SQL Server Read MoreThe SQL Server error 15023 User already exists in current database occurs when a databases is restored from another instance. The database users aren’t mapped to the corresponding logins at the …
SQL Server error 15023 User already exists in current database Read MoreHere is a way to restore database backup using SQL script. The first step is to get the logical file names contained in the backup device. — get file names from …
Restore database backup using SQL script Read More