Query to find the customer with list ...

Query to find the customer with list of products and total price of the purchased products http://ping.fm/xOPEy

250+ SQL Queries Interview Question A...

250+ SQL Queries Interview Question Answers - SQL Interview Queries Question / Questions Answers This is a never end... http://ping.fm/Uy2Kq

HOW SQL Experience Resume looks like ...

HOW SQL Experience Resume looks like ? - A sample SQL Experience Resume, who has 5 years of experience.   Recen... http://ping.fm/NIL7B

Deadlock Analysis ? READ Deadlock fro...

Deadlock Analysis – READ Deadlock from SQL ERRORLOG - How to read DEADLOCK Information in SQL Server ERRORLOG ? In o... http://ping.fm/3lLzN

Example of Deadlock | SQL Server Dead...

Example of Deadlock | SQL Server Deadlock Script - IS there a way I can stimulate a deadlock in SQL Server, so that ... http://ping.fm/00qFq

How to backup SQL table ? - Backup SQ...

How to backup SQL table ? - Backup SQL table, have you ever tried to backup a single SQL table inside a database? DO... http://ping.fm/wmHvQ

SQL for Android operating System - Do...

SQL for Android operating System - Do we have SQL Server Android, My business objective for this question is Can I... http://ping.fm/kclrT

Is sql server an operating system ? -...

Is sql server an operating system ? - Recently in an interview, Interviewer asked me a question, "Is sql server... http://ping.fm/cRRmA

SQL Server copy data from one databas...

SQL Server copy data from one database to another - I need to copy the data from one database to another another, is... http://ping.fm/6eLc2

What is ACT Database Software ? - Wha...

What is ACT Database Software ? - What is ACT Database Software ? http://ping.fm/HHCYu

PUBS and Northwind Database for SQL S...

PUBS and Northwind Database for SQL Server 2012 - I am looking for some sample database to test some new features of... http://ping.fm/e4Eiv

SHRINK LOG File SQL

SQL Server Database Log File has grown exponentially over a period of time and now causing DISK space issue, how to reduce | Shrink Log file (.ldf) size?

Steps to truncating log files and shrinking your database

1. Get logical / physical name of your database log file (LDF)
2. Truncate LOG File
3. Shrink LOG File

Let's see how we SHRINK LOG File using TSQL

STEP 1 - Get logical / physical name of your database log file

use <[your database name]>
exec sp_helpfile

STEP 2 - Truncate LOG File

-- replace <[your database logical log filename]> with Logical file name, which we get in STEP 1
USE <[your database name]>
GO
BACKUP LOG <[your database logical log filename]> WITH TRUNCATE_ONLY
GO

STEP 3 - Shrink LOG File

-- replace <[your database logical log filename]> with Logical file name, which we get in STEP 1
USE <[your database name]>
GO
DBCC SHRINKFILE (<[your database logical log filename]>, 1) 
GO

Let's see how we

SHRINK LOG File using SQL Server Management Studio (SSMS)

50 Database Optimization TIPS - Datab...

50 Database Optimization TIPS - Database Optimization helps any system to perform work efficiently and quickly. SQL ... http://ping.fm/JvPJK

How can i check all the jobs schedule...

How can i check all the jobs scheduled time and next run time. http://ping.fm/RUHN7

What is Contained Database in SQL Ser...

What is Contained Database in SQL Server ? - What is Contained Database ? Why Contained Databases feature was Requir... http://ping.fm/oMshl

Sample SQL Server database for 2012 A...

Sample SQL Server database for 2012 Adventure Works Download http://ping.fm/BxW6f

USE Database Recovery Advisory | TIME...

USE Database Recovery Advisory | TIMELINE Restore SQL Server http://ping.fm/w5oRL

SQL Server Error 2 ? Microsoft Soluti...

SQL Server Error 2 – Microsoft Solution - Microsoft SQL Server Error 2 Error when attempting to log into SQL Server ... http://ping.fm/9knv8

SQL Server Version List - How to chec...

SQL Server Version List - How to check SQL Server Version ? SQL Server Version can be checked by running the followi... http://ping.fm/wV5HE

How to Monitor SQL Server Backups ? -...

How to Monitor SQL Server Backups ? - In my last post, “10 SQL Server Disaster Recovery Solutions”  I discussed... http://ping.fm/kQmmd

10 SQL Server Disaster Recovery Solut...

10 SQL Server Disaster Recovery Solutions - What is SQL Server Disaster? Disaster is an event that makes continuatio... http://ping.fm/Akdpr

Install SQL Server 2012 Step by Step ...

Install SQL Server 2012 Step by Step Screen Shot - Today, my Evaluation edition expired and need to rebuilt my virtu... http://ping.fm/fd8mO

SQL Server Recovery Model affect Perf...

SQL Server Recovery Model affect Performance ? http://ping.fm/qcsiY

10 Difference between SIMPLE vs FULL ...

10 Difference between SIMPLE vs FULL recovery model http://ping.fm/3WIO0

Microsoft SQL Server 2012 Launch Even...

Microsoft SQL Server 2012 Launch Event http://ping.fm/tWSvX

Remote SQL DBA - Part time - Hi, I...

Remote SQL DBA - Part time - Hi, I am SQL server DBA having 5 years experience. I am planning to do part time for... http://ping.fm/iKxkS

How can I edit 250th Row in SSMS 2008...

How can I edit 250th Row in SSMS 2008? - I am using SSMS and I want to edit table row and I right clock on SQL table... http://ping.fm/ib8nQ

SQL Database Growth - Hi All, I ha...

SQL Database Growth - Hi All, I have a requirement to get the database growth info from a SQL server .I have a si... http://ping.fm/UTKQk

How to installing SQL Server 2008 R2 ...

How to installing SQL Server 2008 R2 Developer with vsta.exe http://ping.fm/uYS1B

Next generation Windows File System ?...

Next generation Windows File System – ReFS http://ping.fm/9t8YC

Tasks to be performed by a DBA incase...

Tasks to be performed by a DBA incase his new Job has a Reporting Services Support ? http://ping.fm/wXyJt

101 SQL Server Reporting Services Int...

101 SQL Server Reporting Services Interview Questions with Answers http://ping.fm/yOad6

VIDEO?How to RECOVER Corrupted Databa...

VIDEO–How to RECOVER Corrupted Database ? http://ping.fm/bd4zD

Answered: How to FIX SQL Server Error...

Answered: How to FIX SQL Server Error 8966 - Unable to read and latch page 54 with latch type string string failed http://ping.fm/1Bgg2

Answered: How to FIX SQL Server Error...

Answered: How to FIX SQL Server Error 18054 - error 18054, severity 16, state 17 was raised, but no message with tha... http://ping.fm/42D7c

How to Restore only Corrupted pages f...

How to Restore only Corrupted pages from a database backup ? VIDEO http://ping.fm/qiw2W

Answered: Performance tuning tips for...

Answered: Performance tuning tips for developers !!! - you can download a quick white paper mentioning all details a... http://ping.fm/2tyJt

DBCC SQLPERF(LOGSPACE) corrected in S...

DBCC SQLPERF(LOGSPACE) corrected in SQL Server 2012 RC0 http://ping.fm/2Pz7d

Sql Server Enterprise Edition on Clie...

Sql Server Enterprise Edition on Client System failed - Can I install SQL Server enterprise edition in Client System... http://ping.fm/cRuID

SQL Server Error 3241 - SQL Server 32...

SQL Server Error 3241 - SQL Server 3241 (sql Error 3241) occurs during restoration of SQL Database from a backup whi... http://ping.fm/OfEe4

SQL server 2012 Release Date - SQL Se...

SQL server 2012 Release Date - SQL Server 2012 was expected to be released in Q1 of 2012 (might be in February, 2012... http://ping.fm/dYnAz

PARSE in sql - SQL Server 2012 has in...

PARSE in sql - SQL Server 2012 has introduces a new function PARSE() to translate the result of an expression to sp http://ping.fm/sQX3M

SQL SERVER MCM Study Group - SQL Serv...

SQL SERVER MCM Study Group - SQL Server MCM is the hottest Certification, which is the highest level of Certificatio... http://ping.fm/q2OmU