SQLSkills blogspot

My Experience with SQL Server:

DBA Useful Keys: DBA Scripts for SQL & DBA Scripts for SQLServer & DB2 Performance Scripts & SQL Server Performance Scripts & General Useful Commands for Windows & General Useful Commands for UNIX

For DBAKeys(DB2)Visit My DB2 Blog: http://db2key.blogspot.com

Search This Blog

GUNNU

MySQLSkill.blogspot.com

View my complete profile

SQL SERVER : Diagnostic Information Queries

SQL Server 2014 Diagnostic Information Queries

SQL Server 2012 Diagnostic Information Queries

SQL Server 2008 and 2008 R2 Diagnostic Information Queries

SQL Server 2008 Diagnostic Information Queries

SQL Server 2005 Diagnostic Information Queries

SQL Server 2014 Blank Results

SQL Server 2012 Blank Results

SQL Server 2008 R2 Blank Results

SQL Server 2008 Blank Results

SQL Server 2005 Blank Results

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

Newer Post Older Post Home

Total Pageviews

Labels

1.SQL : Create All databases Backup (Full//Diff/Log) (1)
1.SQL Best Practice (61)
2.Script to find missing indexes in all databases of a server using DMVs (1)
2008 (1)
3.Powershell: SQL Script to truncate SQL log files for all user databases (1)
4.Rebuilding or Reorganising indexes for a SQL database (1)
5.Restore all SQL databases in a Directory to Instance using a Script (1)
5Start (1)
6.Run SQL Query with Multi Database Query with Registered Servers (1)
7.SQL Servers: Find all SQL Services defualt login ID's (1)
8 Steps to better Transaction Log throughput (1)
A Small Collection of DBCC Commands (2)
A Small Collection of DBCC Commands Part 2 (1)
Accessing Registry using XPs (1)
Active connections (1)
Active Directory (3)
Active Directory Objects & Local Policies summary (2)
Active SQL Server connections (1)
Activity monitor (1)
add node in SQL Server 2008 (1)
Add Node to failover cluster installation (1)
Adding Storage to SQL Server 2008 Cluster (1)
Advanced SQL Server performance tuning (2)
Advanced SQL Server performance tuning Tips (1)
Are DBCC's being done? (1)
Assigning Lock pages in Memory in SQL Server (1)
Auto create stats turned on sql database (1)
Auto generate SQL Server database restore scripts (3)
Automating daily transaction log reading (1)
Backing Up a SQL Server Database Directly (1)
Backup Compression (1)
Backup Compression CPU Cost (1)
Backup Monitoring and Reporting (1)
Backups of a higher version cannot be restored on a lower version of SQL Server (1)
Backups: Recovery Models and Backup Types (2)
Batch script: Automatic Shutting down Server (1)
Best Practices for applying SQL Server Service Packs (1)
Best Script (2)
Bug: log file growth broken for multiples of 4GB (1)
bulk-logged recovery model (1)
by querying metadata (1)
Cannot connect to a SQL Server 2008 named instance; How to resolve (1)
Change SQL Collation (1)
Change SQL Collation without rebuilding system databases (1)
CHECK Constraint (1)
Check SQL User Account Status (1)
check when was SQL Server restarted (1)
CHECKDB (2)
CHECKPOINT (1)
Clean Old db backup files (1)
Cleaning up orphaned users in SQL Server (1)
cluster (1)
Code to Generate the ALTER INDEX Statements (1)
Code to Generate the DISABLE Command (1)
Code to list potential cluster key space savings per table (1)
Column length and Data length (1)
Common SQL Server Security Mistakes (1)
Compare features in different High Availability options in Sql Server (1)
compatibility level (1)
Complete description of all CHECKDB stages (1)
CONCAT – New String Function in SQL Server 2012 (1)
Configuring user permissions for Microsoft SQL Agent (1)
constrains (1)
Copy DB files from one drive to another using Robocopy (1)
Copy DB from Instance to Another Instance (1)
copy DB from one machine to another (1)
Copy table from one database to another (1)
COPY_ONLY Backups with SQL Server (1)
Corruptions fatal to DBCC CHECKDB (1)
Count number of words in a string (1)
COUNT_BIG(*) (1)
COUNT(*) for larger tables (1)
Create a CHECK Constraint to allow specific values (1)
create a new Windows Login (1)
CREATE SAMPLE DATABASE (2)
creator and locaton details (1)
Current SQL Server (1)
Current SQL Server Details (1)
custered instance (1)
Data Management Report (1)
Database Compatibility Level for SQL Server 2012 (1)
Database Engine (1)
Database Maintance (2)
Database maintenance (6)
database mirroring (5)
database physical physical files and associated reads (1)
Database Refresh in SQL (1)
Database RESTORE error Msg 3183 (1)
dataFiles (2)
date format (1)
DATEPART (1)
db backup types (1)
DB created date and SQL Server restarted time (1)
DB Inventory (1)
DB Restore history (1)
DBA (4)
DBA Interview (2)
DBCC Commands (5)
DBCC DROPCLEANBUFFERS (1)
DBCC FREEPROCCACHE (1)
DBCC SHOWCONTIG (1)
DBCC SHOWCONTIG was replaced by sys.dm_db_index_physical_stats (1)
DBCC SHRINK DATABASE Predict time.DBCC SHRINKDATABASE (1)
DBCC SHRINKFILE (2)
deadlock Notification (1)
Debunking a full database backups (1)
DEFRAGMENT INDEXES (1)
DELETE (1)
Delete all the tables (1)
Deprecated SQL Server 2008 commands (1)
Details (1)
Detecting and Correcting Database Corruption (1)
Diagnostic Information Queries (7)
Difference between Drop (1)
Difference between Stored Procedure and Functions (1)
Different DATETIME formats (1)
Different techniques to identify blocking in SQL Server (1)
Differential (1)
Directory naming convention in SQL Server (1)
Document Types that are NOT present in the full-text index (1)
Does rebuilding clustered index automatically rebuild non clustered indexes (1)
Don’t grant db_owner (1)
Drop all tables.Remove all functions (1)
DROP FUNCTION (1)
DROP PROCEDURE (1)
DROP TABLE (1)
Dynamically restore full and all transaction log backup (2)
Enable SQL Pages Memory (1)
Enabling Transparent Data Encryption on SQL Server 2014 (1)
Encrypting the Database (1)
Error when trying to create a new Windows Login(15401) (1)
Error Installing SQL Server Cluster - The cluster resource could not be brought online (1)
Error When Creating Windows 2008 R2 Cluster - The argument is null or empty string. Parameter name: domainName (1)
EXECUTE master.dbo.xp_delete_file (1)
Extract only numbers from a String (1)
failover cluster Installation MS SQL Server 2008 (1)
Failover Clustering (3)
Failover Clustering (Full Details Link) (1)
Find all permissions/access for all users (2)
Find all the database information from sys.databases (1)
Find list of Reserved Keywords used as column names or table names (1)
Find Primary Keys Foreign Keys or Constraints in a database (1)
Find SQL Foreign Keys (1)
Find SQL Constraints (1)
Find SQL Orphan Users and Fix using ALTER USER (2)
Find SQL Primary Keys (1)
Find SQL Server Backup File Version (1)
Find SQL Server Internal Version Number (1)
Find TCP/IP Port Number SQL Instance (1)
Find the Size of Database File (1)
find the size of every index in the db (1)
Find the sql version of a Database Backup file / MDF file (1)
Find the unused database tables in SQL Server (1)
Finding Databases which had Transaction Log Growth (1)
Finding out who dropped a table using the transaction log (1)
Finding Sysadmins on a SQL Instance (1)
Finding the list of nodes in a Failover Cluster (1)
Fix SQL Server Agent on Windows Failover Cluster (1)
forget sql password (1)
full (2)
Generate a security report on SQL Server instance - Security script (1)
Generate SQL Server All databases restore scripts (1)
generate sql table scripts through query (1)
Generate sql table scripts through SSMS (1)
Generating INSERT statements for a table (1)
Get a list of all the DBCC commands (1)
Get count(*) on all tables with very little overhead (without table scan) (1)
Get current instances services (1)
Get Current SQL Server Details: (1)
Get Current SQL Services (2)
Get multiple instances services (1)
GET SQL OS Information (1)
Get SQL Server Version (1)
Get the list current Jobs in SQL Server: (1)
Get the SQL Server Logins( ORPHAN Users) (1)
Good (1)
GOOD SCRIPTS (12)
grant db_owner in SQL Server (1)
Grant permissions to users to create jobs in Sql Server (1)
Grouping of SQL Servers (1)
High Availability (3)
Hot Scripts (1)
How big are your SQL Server database files? Where are they? (1)
How can I open an .MDF file in SQL Server? (Attach Tutorial & Troubleshooting) (1)
How do checkpoints work and what gets logged (1)
How do we collect SQL Server backup details from the system tables? (1)
How many data files do I need for TempDB (1)
How many IP addresses for cluster? (1)
How much of the SQL database has changed since the last full backup? (1)
how much sql data will the next log backup include? (1)
how much transaction log a full backup includes (1)
How often checkdb should be run against database (1)
How Recursive Common Table Expression (CTE) Works in SQL Server (1)
How to access a newly installed SQL Server 2008 R2 instance if you do not know the login and password (1)
How to add a Windows user to the sysadmin fixed server role in SQL Server 2005 as a failure recovery mechanism (1)
How to add node to SQL Server cluster (1)
How to Change the Order of Columns in a Table( SQL Server) (1)
HOW TO CHECK IF A USER ACCOUNT IS LOCKED (1)
How to cleanup SQL old backup files (1)
How to connect SQL Server using DAC on New Query Window(SSMS) (1)
How to create a trace from sql server profiler (1)
HOW TO CREATE CLUSTER USING HYPER-V (1)
How to create log shipping in SQL Server (1)
How to create SQL Server 2005 Clustering (Part 1) (1)
How to create SQL Server 2005 Clustering (Part 2) (1)
How to create SQL Server 2005 Clustering (Part 3) (1)
How to create SQL Server 2005 Clustering (Part 4) (1)
How to create SQL Server 2005 Clustering (Part 5) (1)
How to create table with filestream column and Insert data (1)
HOW TO DEFRAGMENT INDEXES USING SCRIPT IN SQL SERVER 2005/2008 (2)
How to delete multiple logins from SQL Server (Sp_DropLogins) (1)
How to delete/drop all the tables (1)
How to enable and configure Filestream in SQL SERVER 2008 / 2012 (1)
How to find if there is a trace running in the server (1)
How to find size of SQL backup files in a folder? SQL Backup Files Size (1)
How to find the model name or serial number of a Windows server (1)
How to Generate Insert Scripts for Existing Data (1)
How to get list of all SQL Server Service Accounts using T-Sql (1)
How to get the SQL Database property settings value (1)
How to import sql server profiler trace file into table (1)
How to invoke a SQL job from another Job present on a different instance (1)
How to log off remote desktop users from a remote machine (1)
How to migrate a SQL Server database to a lower version (1)
How to Move the System Databases (1)
How to Move User Databases (1)
How to move your SQL Server transaction log? (1)
How to notify client about progress made using frequent PRINT statements (1)
How to Predict the DBCC SHRINK DATABASE finish time (1)
How to read the content of one or more trace files (1)
How to read the SQL Server Database Transaction Log (2)
How to rebuild HEAP tables including its nonclustered indexes (1)
How to rename your SQL Server (1)
how to start SQL Server in Single User mode? (1)
How to start sql server without tempdb (1)
How to transfer logins and passwords between instances of SQL Server (1)
How to transfer logins and passwords between instances of SQL Server - Part 1 (1)
How to Troubleshoot SQL Server Connection Problems (1)
Identify the SQL Server Service Accounts using t SQL (1)
IF LOCKED HOW TO UNLOCK IT (1)
In-memory OLTP Engine in SQL Server 2014 CTP2 (1)
Increase the Number of SQL Server Error Logs (1)
Info about SQL Backup (2)
Install Sample Databases in SQL Server 2008 R2 (1)
Installing .NET 3.5 Framework in Windows Server 2008 R2 (1)
Installing SQL 2008 R2 Cluster Step-By-Step (1)
Installing SQL Server 2008 R2 (3)
Installing SQL Server 2008 R2 Client (1)
Installing SQL Server 2008 R2 Service Pack 1 (1)
Installing SQL Server 2008 R2 side by side with SQL Server 2008 (1)
Installing SQL Server 2008 Service Pack 3 on Multiple Instances (1)
Installing SQL Server 2012 (2)
Installing the SQL Failover Cluster in Windows Server 2008 (1)
Interview Do's & Dont's (1)
INTERVIEW Q&A (1)
Is it a good idea to run DBCC SHRINKDATABASE regularly? (1)
is that SQL database REALLY in the FULL recovery mode? (1)
Last backup (1)
last time STATISTICs were updated on a table (1)
Level 16 (2)
Line 1 (1)
Line 1 Cannot open backup device Operating system error 53 (1)
List all users of all databases with all roles (1)
List of All Permissions a Users in SQL Server (2)
list of all Stored Procedures script (1)
List of all users db roles for all databases (1)
list user db roles (1)
log backup fail but a full backup succeed (1)
Log Shipping (1)
log shipping in SQL Server (1)
LogFiles (2)
Lost all Administrator Account in SQL Server and Forgot sa Account Password (1)
Map All Orphan Users to Logins else create login and map (1)
Maximum number of supported nodes in a cluster (1)
Memory configuration in SQL server and break up of memory utilized by SQL server (1)
Memory Optimization Advisor (1)
Merge Replication Step by Step Procedure (SQL2005) (1)
Merge Replication Step by Step Procedure(SQL2000) (1)
Microsoft Distributed Transaction Coordinator (1)
Microsoft Failover cluster 2008 Moving MSDTC to new SAN disk (2)
Microsoft Failover cluster 2008: Moving MSDTC to new SAN disk (1)
Microsoft SQL Server (4)
Microsoft SQL Server: (1)
Microsoft SQL Server: Accessing Registry using XPs (1)
Microsoft SSIS (2)
Mirrored Database Backups (1)
Monitor current SQL Server processes (1)
Monitor SQL Server Performance and Activity (1)
Monitoring Daily Backups (1)
Monitoring SQL Server database transaction log usage (1)
Move Master Database (1)
MOVE TEMP DB IN SQL SERVER 2005/2008 R2 (2)
Move the Tempdb database to new location (1)
Move User DBs using Taking the Database Offline Method (1)
Move User DBs using the Detach/Attach Method (1)
Moving a database while Database Mirroring is running (1)
Moving SQL Databases (1)
Moving the msdb and model Database (1)
Moving the Resource Database (1)
MS SQL FAILOVER CLUSTER (4)
MS SQL Performance: (18)
MS SQL Server 2005 - failover cluster Installation (1)
MS SQL Server 2008 - fail over cluster installation on Windows Server 2003 EE (1)
MS SQL Server 2008 Fail over cluster installation on Windows Server 2008 R2 (1)
MS SQL Server 2012 failover cluster install (1)
MS SQL Server 2012 failover cluster installation on Windows Server 2012 R2 (1)
MS SQL SERVER 2012 NEW FEATURES (1)
MS SQL Server DBA Checklist - High Availability - Clustering (1)
MS SQL Server Port Number (2)
MSDTC (1)
MSDTC Recommendations on SQL Failover Cluster (1)
Msg 3201 (1)
MSSQL (2)
MSSQL DBA Check List (3)
MSSQL Find PORT Number (1)
MSSQL Interview Questions (1)
Multi-server queries (1)
multiple backup (1)
Naming a SQL Server Instance (1)
New Features (1)
New monitoring tool in Sql Server 2008 (1)
Non-Standard SQL Port (1)
OFFSET and FETCH – New in SQL Server 2012 (1)
Outputting DBCC results (1)
parameterized (1)
Partition-level lock escalation details and examples (1)
per database (1)
Performance issues from wasted buffer pool memory (2)
Performance Studio (1)
PowerShell (2)
PowerShell Script to Install SQL Server Service Pack (1)
Pre Requires for Installing SQL 2008 R2 Cluster (1)
Prerequisites - Microsoft SQL Server 2005 failover cluster install (1)
Prerequisites - Microsoft SQL Server 2008 failover cluster install (1)
Prerequisites for MS SQL Server 2012 failover cluster install (1)
Prevent Accidental Drop Database (1)
Procedures fro Database (1)
Query for SQL Server database file size (1)
Query for Stored Procedure parameter details (1)
Querying read long Text Columns in SSMS (1)
Quick Check (1)
Quick Check on Fragmentation (1)
Quorum Error When Creating an AlwaysOn Availibility Group (1)
Read SQL Log file (4)
Read the SQL Server Database Transaction Log (1)
Reading the SQL Server log files using TSQL (2)
Rebuild index (2)
Rebuild Master Database in SQL Server 2000 (1)
Rebuild Master Database in SQL Server 2005 (1)
Rebuild Master Database in SQL Server 2008R2 (1)
Rebuilding Master Database in SQL Server (1)
Recently modified Objects in SQL Server (1)
Recover lost sa password (1)
RecoveryModel (3)
Reduce Time for SQL Server Index Rebuilds and Update Statistics (1)
Relocate TEMP DB (1)
Remove duplicate characters from a string (1)
Rename your SQL Server database files (1)
Replication (6)
Reset sa password (1)
RESIZE TEMP DB (1)
resource and User Databases to New SAN disk (1)
Restore a SQL Server database to a new server? (3)
RESTORE DATABASE is terminating abnormally (1)
RESTORE DATABASE is terminating abnormally. (1)
Restore DB (5)
RESTORE FILELISTONLY (1)
RESTORE HEADERONLY (1)
Restore master database on a cluster instance (1)
Restore tempdb (2)
RESTORE VERIFYONLY (1)
restoring a log-shipping log backup be slow (1)
Restrictions we have on TempDB (1)
Reverting your SQL Server database back to a specific point in time(STOPAT) (1)
Robocopy files to another Drive (1)
Rollback (1)
Run a SQL Query on multiple servers (1)
Run a SQL Query on multiple servers and save output to excel using power shell (1)
Run query in multiple servers (1)
SAMPLE DATABASE (3)
Sample Database for Common Table Expressions (1)
Script for backup all databases in SQL Server (1)
Script to create table script using Query (1)
Script to find Head blocker- SQL Server 2005 (1)
SCRIPT TO LIST ALL SQL SERVER LOGINS (2)
Scripts (1)
Search column name in SQL Server (1)
SELECT @@VERSION (1)
Server Naming Convention (1)
Server space management (1)
Servername (1)
Service Pack or Update for SQL Server 2008/R2/2012 fails without generating the setup log files (1)
Setting up Merge Replication in SQL Server 2000 (1)
Setting up Merge Replication in SQL Server 2005 (1)
Setting up Transactional Replication in SQL Server 2008 R2 (1)
Setup SQL Server 2012 - AlwaysOn Availability Group Configuration.SQL Server 2012 (1)
Should you enable Instant File Initialization for your SQL Server? (1)
Shrinking a Log File (1)
Shrinking a Log File on a Test or Development Server (1)
Shrinking All dbs Transaction Log (1)
simple (1)
Simple script to backup all SQL Server databases (1)
Some known issues with SSMS (1)
sp_cycle_errorlog (1)
sp_Health (1)
Split backups in SQL Server (1)
SQL (1)
SQL DATE and TIME related functions (1)
SQL : What filegrowth are you using for your database files? (1)
SQL 2008 (4)
SQL 2008 High Availability (1)
SQL 2012 (2)
SQL 2012 Always On Status Report (1)
SQL 2014 (1)
SQL Add a column in a specific position in a table (1)
SQL Add Column Position (1)
SQL AGENT ERROR (1)
SQL Agent Jobs getting Suspended State (1)
SQL ALL DBS Information (1)
SQL Auditing (3)
SQL backup (16)
SQL Backup Compression (2)
SQL Backup Database in differnt drives. (1)
SQL Backup Database in multiple files (1)
SQL Backup History (4)
SQL Backup Scripts (2)
SQL Blocking (2)
SQL Caveats of a CONTROL SERVER permission (1)
SQL Change db multiple use mode (1)
SQL Change db single use mode (1)
SQL CLUSTE (1)
SQL Cluster (7)
SQL CLUSTER TIPS (7)
SQL COMMANDS (1)
SQL current running queries (1)
SQL current running queries count (1)
SQL Database snapshots – when things go wrong (1)
SQL Database takes long time to Recover during startup/Restore (1)
SQL DB DashBoard (1)
SQL DB Settings (1)
SQL DB Size (2)
SQL DBA (3)
sql demo database (1)
sql demo scripts (1)
SQL Error (4)
SQL Error log (1)
SQL Faqs (2)
SQL FILESTREAM directory structure (1)
SQL Full backup (2)
SQL Governor (1)
SQL HEALTH CHECK SCRIPT (3)
SQL Hide database (1)
SQL Index (1)
SQL Index Usage (1)
SQL Indexes and their usage details (2)
SQL Inside the Storage Engine (1)
SQL ISDATE() with care (1)
SQL JOBS (2)
SQL Kill all sessions (1)
SQL list of all db create date (2)
sql log backup (1)
SQL LOG Files (2)
SQL Log Shipping (2)
SQL Mail (1)
SQL memory configuration (1)
SQL Memory usage (2)
SQL Mirroring Setup (2008R2) (2)
SQL Mirroring Status (1)
SQL Missing Indexes (1)
SQL Monitoring (2)
SQL Orphan Users (9)
SQL Orphan Users (2005/2008/2012) (2)
SQL Orphan Users (SQL7/2000) (2)
SQL Orphan Users Full details (1)
SQL Parsing a string (1)
SQL Performance Queries (DMV Queries) (1)
SQL Port (2)
SQL Port 1433 (3)
SQL Profiler (2)
SQL Query Database Size (1)
SQL Query Import Images (1)
SQL Query Tuning (2)
SQL Recovery (5)
SQL Recovery models (1)
SQL Recovery Steps (2)
SQL Regular expression (1)
SQL Removing tags from a string (1)
SQL RENAME DB (1)
SQL Replication (5)
SQL Resource Governor Configuration (1)
SQL Restore (6)
SQL Restore Database Backup From Another Server (1)
SQL Rollback TRUNCATE TABLE statement (1)
SQL Scripts (29)
SQL Server (2)
SQL Server - Index Fragmentation - Understanding Fragmentation (1)
SQL SERVER – 2008 – Copy table to another table With Data – Generate T-SQL For Inserting Data From One Table to Another Table (1)
SQL Server : Find missing Indexes (1)
SQL Server : How to check the Authentication Mode with tSQL. (1)
SQL Server : Retrieve memory details from the OS (1)
SQL Server :Table counts (1)
SQL Server :Total number of active/open connections (1)
SQL Server :Transfer users from SQL 2000 to SQL 2005 (1)
SQL SERVER 12 Best Practices for Better Database Performance (1)
SQL Server 2005 Diagnostic Information Queries (1)
SQL Server 2005 Diagnostic Information Queries - Part 2 (1)
SQL Server 2008 (6)
SQL Server 2008 Diagnostic Information Queries (1)
SQL Server 2008 High Availability whitepaper published on MSDN (1)
SQL Server 2008 New Features (2)
Sql Server 2008 R2 (2)
SQL Server 2008 R2 Diagnostic Information Queries (1)
SQL Server 2008r2 and SQL Server2012 (1)
sql server 2012 (4)
SQL Server 2012 - Database Mirroring Configuration (2)
SQL Server 2012 – Installation Failed (1)
SQL Server 2012 Configuration Manager WMI Error – Remote Procedure call failed [0x800706be] (1)
SQL Server 2012 Diagnostic Information Queries (1)
SQL Server 2012- Sample Databases (1)
SQL Server 2012:How to enable the Lock Pages in Memory Option (1)
SQL Server 2014 (8)
SQL Server 2014 CTP 1 – Installation failure (1)
SQL Server 2014 CTP 2 – Installation (1)
SQL Server 2014 CTP 2 : Native Backup Encryption (1)
SQL Server 2014 CTP2 – Memory Optimization Advisor (1)
SQL Server 2014 Diagnostic Information Queries (1)
SQL Server 2014 In-Memory Optimizer (1)
SQL Server 2014 New Features (5)
SQL Server 2014 Real Time Query Monitoring (1)
SQL Server Agent Could not be started (reason: Error creating new session) - Error 15247 (1)
SQL Server Architecture of Transaction Log (1)
SQL Server BACKUP DATABASE (2)
SQL Server BACKUP LOG (1)
SQL Server Backup Types (1)
SQL Server Best Practices for using Service Accounts (1)
SQL Server Change Data Capture (CDC) for Auditing (1)
SQL Server Clusters (26)
SQL Server Compare Two Tables Using T-SQL or Command Line Utility (1)
SQL Server Complete Over View (1)
SQL SERVER Copy Data from One Table to Another Table (1)
SQL Server CPUs -- physical (1)
SQL Server Data File Structure (1)
SQL Server Database (1)
SQL Server Database Backup and Restore Error or Failure Notifications (1)
SQL Server Database Backup Errors (1)
SQL Server Database Filegroup is Full (1)
SQL Server Database Restore Error (1)
SQL Server db backup history (4)
SQL Server DBA Backup and Recovery Interview Questions (1)
SQL Server DBA Daily task (1)
SQL Server Deadlock Notifications (1)
SQL Server Dedicated Administrator Connections(DAC) (1)
SQL Server DEMO Scripts (1)
SQL Server Demos and Sample Databases (1)
SQL Server Disk Configuration Checklist (1)
SQL Server Error Log (1)
SQL Server Error Log Management (1)
SQL Server Failover Cluster (Complete reference) (1)
SQL Server fails to Start-Troubleshooting the failure (1)
SQL Server Find Free Space in Database Files (1)
SQL Server Find the database restore history (1)
SQL Server Find the Size of Database File – Find the Size of Log File (1)
SQL Server Finding the Orphaned Users (1)
SQL Server First date and last date of previous month (1)
SQL Server Free space available in Database (1)
SQL Server GETDATE () (1)
SQL Server in Single User mode (1)
SQL Server Index Fragmentation (3)
SQL Server Indexing best practices (1)
SQL Server information (2)
SQL Server Instant Blocking Alert Using WMI in Your Mailbox (1)
SQL Server Instant Deadlock Alert Using WMI in Your Mailbox (1)
SQL Server internal database versions (1)
SQL Server Interview Questions (1)
SQL Server Isolation levels (1)
SQL Server Jobs (1)
SQL Server List Login's Database and Server Level Role Permission (1)
SQL Server List of db_owner granted permissions (1)
SQL Server Locking Statements (1)
SQL SERVER LOG FILE (2)
SQL SERVER LOG FILE BY REDUCING NUMBER OF VIRTUAL LOG FILE (1)
SQL Server Log File Viewer (1)
SQL Server Logfiles (1)
SQL Server Management Studio 2008’s Group Query Execute (1)
SQL Server Measuring The Index Fragmentation (1)
SQL Server Memory usage in Buffer Pool (2)
SQL Server Memory used by a database (2)
SQL Server Mirrored Database Backups (1)
SQL SERVER MONITORING (3)
SQL SERVER MONITORING: SQL Query Database Size (1)
SQL SERVER MONITORING: SQL Query Table size and Row Count & Column Count (1)
SQL SERVER MONITORING: SQL Server Read Error Log from SSMS (1)
SQL SERVER MONITORING:SQL Server Local Drive Details (1)
SQL Server Moving System (1)
SQL Server Name (1)
SQL Server overview of Log Shipping (1)
SQL Server Performance (1)
SQL Server Performance Scripts (2)
SQL Server performance tuning (9)
SQL Server Permissions Hierarchy (1)
SQL Server Prevent Accidental Database Drop with DDL Triggers (1)
SQL Server Primary Keys without clustered indexes (1)
SQL Server Profiler Pointers (1)
SQL Server rebuilding all table indexes (1)
SQL Server Recovery Model overview (1)
SQL Server recovery models (2)
SQL Server Removing unwanted characters (1)
SQL Server Replace data of one table with data of other table (1)
SQL Server Replication Step by Step (2)
SQL Server Restarted Time (1)
SQL Server Restore Master Database (3)
SQL Server Restore the Database from the Backup file (1)
SQL Server Scheduler (1)
SQL Server Script out Procedures to seperate files (1)
SQL Server script to find out all Stored Procedures that run at SQL Startup (1)
SQL Server Search a value in character column of all tables (1)
SQL Server Service account details. SQL Audit (1)
SQL Server Service Packs (3)
SQL Server Setting up Server Side Trace (1)
SQL Server Skip Successful Backup Messages in SQL Error log and Windows Log (1)
SQL Server Start Time (1)
SQL Server System Databases (2)
SQL Server Temp DB Add Multiple Data Files to Improve Performance (1)
SQL Server TEMPDB (1)
SQL SERVER The Scene Behind NOLOCK (1)
SQL server to get the current time (1)
SQL Server to get the current time format conversion (1)
SQL Server Top 10 Most CPU Consuming Queries (1)
SQL Server Top 10 sessions by maximum memory usage (1)
SQL Server track database data file size increase for any given database (1)
SQL Server Tuning Tips (2)
SQL Server Understanding the Data Page Structure (1)
SQL Server Uptime from SSMS (1)
SQL Server Virtual Log Files (1)
SQL Server: All About SQL Server Statistics :Density Vector (1)
SQL Server: Approaching Database Server Performance Issues (1)
SQL server: Blocking issue (1)
SQL SERVER: Find when stored procedure was last executed? (1)
SQL Server: how to use Tablediff.exe tool (Compare Two Datasources) (1)
SQL Server: Measuring The Index Fragmentation (1)
SQL Server: Msg 3013 RESTORE DATABASE is terminating abnormally (1)
SQL Server: Performance Tuning (Understanding Set Statistics Time output) (1)
SQL Server: Sending Email in HTML Table Format Using TSQL (1)
SQL Server:Backup multiple databases Using with Scripts (1)
SQL Server:How do you find your most accessed tables? When is the last time each table was accesseed? (1)
SQL Server:Last Record Written (1)
SQL Server:When was CHECKDB last run on your databases? (2)
SQL Server’s Index health check (1)
SQL ServerProperty Info (1)
SQL Service Pack (1)
SQL Simple and Forced Parameterization (1)
SQL Sripts (1)
SQL String searching (1)
SQL TEMP DB (4)
SQL Tempdb log is full (3)
SQL TIPS (10)
SQL to check Data and Log Files are on same drive or not (1)
SQL to list index counts per table (1)
SQL Trace File (1)
SQL Transaction log (11)
SQL Transaction log Size (1)
SQL Transactional Replication (1)
SQL Truncate All Tables (1)
SQL USERS Completed Reference (2)
SQL VERSION (1)
sql version of a Database Backup file (1)
SQL: Login Users Changes History (1)
SQL: Search ALL tables for a specific column (1)
SQL: Uninstalling SQL Server Service Pack or Hotfix (1)
SQL:Get the list of Sys objects modified in x number of days (1)
SQL:Query to find all user role in the server (1)
SQL:Relocate and Re-size the TempDB (1)
SQL:When was a Database Deleted and by whom (1)
SQL:When was my database last taken Offline or Online (1)
SQLCMD (1)
SQLServer database backup Using with passwords (1)
SQLServer System Databases Backup (1)
SQLVersion (1)
Squeeze Function (1)
SSIS (1)
SSIS:Query to find last run status of scheduled Jobs (1)
SSIS:SQL Query to find currently running jobs and duration (1)
Star schema (1)
State 2 (2)
Store Perfom Data Collector data to SQL Server (1)
Stored Procedure (1)
Stored Procedure Clean Cache and Clean Buffer (1)
Stripe SQL Backups on multiple files (2)
Successful backup Information in SQL Server Error Log (1)
sys.dm_server_registry (1)
sys.dm_server_services (1)
System Database Maintenance (1)
T-SQL Enhancements in SQL Server 2012 (1)
Table Partition (1)
Table Variable (1)
Tablediff.exe (1)
tables (1)
Tail log backing (1)
TCP Port & IP Address (1)
TCP/IP Port Number (1)
Technical (1)
Temp Table (1)
Temp Table vs Table Variable vs CTE and the use of TEMPDB (1)
TempDB is used for the following purpose (1)
TempDB Space Issue (1)
Top 10 Secrets of Tempdb (1)
Transaction Log (10)
transaction log backup (1)
Transaction Log Backup History (1)
Transaction Log Shrinking (1)
Transaction Log VLFs – too many or too few? (1)
Transactional Replication (1)
Transfer logins and passwords between instances of SQL Server (1)
Transfer logins from one SQL Server 2005 instance to another (1)
TRUNCATE (1)
Truncate and Delete (1)
TRUNCATE vs DELETE (1)
Unable to open SQL Server Configuration Manager (1)
Unable to see SQL Agent in Cluster Admin (1)
Unable to start SQL Server Service on a cluster instance (1)
Understanding Logging and Recovery in SQL Server (1)
Understanding SQL Index Fragmentation (1)
uninstall SQL Server 2012 (1)
Unlock SQL Server Account. (1)
UnUsed Tables (1)
Update statistics (2)
Use Query Governor to Prevent Long Running Queries (1)
User Database Maintenance (1)
Version (1)
virtual and core count (1)
What are SQL Server Statistics? (1)
What is in your SQL Server backup files (1)
What is your Database Mirror status? (1)
What’s in the buffer pool? (1)
What’s my SQL Server Name (1)
When was the last time your SQL Server Service was restarted? (1)
When was the last transaction log backup? (1)
When was your last backup run? (1)
When were the sp_configure options last changed? (1)
Where are sp_configure settings stored? Another reason to backup master… (1)
Which indexes are missing? (1)
Why you should not shrink SQL data files (1)
Windows 2003 EE Failover Cluster Installation on VMware Workstation (1)
Windows 2008 Server Moving Cluster Quorum Disk to New SAN (2)
windows 2012 r2 (1)
Windows Active Directory Interview Questions (1)
Windows Cluster : Understanding the Quorum setting (1)
Windows Cluster: Moving Quorum Disk to Another Node (2)
Windows Desktop Interview Questions and Answers (1)
Windows DHCP Interview Questions and Answers (1)
Windows DNS Server Interview Questions (1)
Windows Log (1)
Windows short cuts (1)
Windows System Administrator command line short cuts to popular MSCs (1)
Wrapping Up (1)
writes and IO (1)
xp_instance_regread (1)
xp_instance_regred (1)
xp_msver (1)
xp_regread (1)

Blog Archive

► 2023 (4)
- ► May (1)
- ► February (3)

► 2019 (1)
- ► September (1)

► 2018 (2)
- ► January (2)

► 2017 (7)
- ► October (7)

► 2016 (1)
- ► February (1)

► 2015 (4)
- ► December (1)
- ► July (1)
- ► January (2)

▼ 2014 (416)
- ► December (24)
- ► November (5)
- ► October (57)
- ► September (46)
- ► August (1)
- ► July (9)
- ► May (16)
- ► April (3)
- ► March (14)
- ▼ February (121)
- ► January (120)

► 2013 (12)
- ► December (11)
- ► October (1)

Pages

Home

Translate

My Blog List

Simple theme. Theme images by Deejpilot. Powered by Blogger.