Blogs about: Sql Data Storage
Featured Blog
SQL create a procedure with update and insert a other table
CREATE PROCEDURE dbo.sp_UpdateLibList @TableId as numeric(18,0), @descr1 as nvarchar(2048), @descr2 as nvarchar(2048) = ‘ ‘, @reftableid as numeric(18,0), @seeal… more →
Script For All
SQL SERVER - Guidelines and Coding Standards Complete List Download
— 3 comments
pinaldave wrote 1 week ago: SQL SERVER - Guidelines and Coding Standards complete List Download Coding standards and guidelines … more →
SQL create a procedure with update and insert a other table
kostland wrote 2 weeks ago: CREATE PROCEDURE dbo.sp_UpdateLibList @TableId as numeric(18,0), @descr1 as nvarchar(2 … more →
SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
— 6 comments
pinaldave wrote 2 weeks ago: Download SQL Server 2008 Interview Questions and Answers Complete List Interview is very important e … more →
SQL SERVER - 2008 - Interview Questions and Answers - Part 8
— 1 comment
pinaldave wrote 2 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download What is Data Compression? … more →
SQL SERVER - 2008 - Interview Questions and Answers - Part 6
pinaldave wrote 3 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download 3) Questions of SQL SERVE … more →
Sql fetch cursors
kostland wrote 1 month ago: DECLARE slip_Update CURSOR FOR SELECT * FROM SlipsTEST, SlipdetailsTEST WHERE SlipsTEST.SlipIdOld = … more →
A smart join with union
kostland wrote 1 month ago: SELECT m.MonthName, COALESCE(c.MonthCost, 0) FROM CostTable c RIGHT JOIN ( SELECT 1 As MonthNumber … more →
SQL SERVER - Query to Find Column From All Tables of Database
— 13 comments
pinaldave wrote 2 months ago: One question came up just a day ago while I was writing SQL SERVER - 2005 - Difference Between INTER … more →
SQL SERVER - FIX - ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.
— 1 comment
pinaldave wrote 2 months ago: ERROR : 9004 An error occurred while processing the log for database. If possible, restore from back … more →
A store procedure for microsoft sql to check win
kostland wrote 2 months ago: This procedure use time… month and day CREATE procedure sp_update_WinHands @month as nvarcha … more →
SQL SERVER - 2008 - Introduction to SPARSE Columns - Part 2
— 6 comments
pinaldave wrote 2 months ago: Previously I wrote about SQL SERVER - 2008 - Introduction to SPARSE Columns. Let us understand the c … more →
SQL SERVER - 2008 - Introduction to SPARSE Columns
— 5 comments
pinaldave wrote 3 months ago: I have been writing recently about how SQL Server 2008 is better in terms of Data Stage and Backup M … more →
SQL SERVER - 2008 - Introduction to Row Compression
— 3 comments
pinaldave wrote 3 months ago: In my previous article SQL SERVER - 2008 - Introduction to New Feature of Backup Compression I wrote … more →
SQL SERVER - 2008 - Introduction to New Feature of Backup Compression
— 3 comments
pinaldave wrote 3 months ago: Backup and Data Storage is my most favorite subject and I have not written about this for some time. … more →
SQL SERVER - Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
— 1 comment
pinaldave wrote 4 months ago: Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies Release Candidate (R … more →
SQL SERVER - SQL Joke, SQL Humor, SQL Laugh - Silly Mistake
— 1 comment
pinaldave wrote 4 months ago: It is really very bad of person to laugh on others misfortune, however dark humor is based on the sa … more →
SQL SERVER - 2005 - Restore Database Using Corrupt Datafiles (.mdf and .ldf) - Part 2
— 2 comments
pinaldave wrote 6 months ago: Blog reader Donald Crowther has posted following comment. I have not tested this solution and when I … more →
SQL SERVER - Sharpen Your Basic SQL Server Skills - Database backup demystified
pinaldave wrote 8 months ago: Read my article in SQL Server Magazine January 2007 Edition I will be not able to post complete arti … more →
SQL SERVER - 2005 - Database Table Partitioning Tutorial - How to Horizontal Partition Database Table
— 14 comments
pinaldave wrote 8 months ago: I have received call from my DBA friend who read my article SQL SERVER - 2005 - Introduction to Part … more →
Have your say. Start a blog.
See our free features →
An 
Creation
