Reading in 2009
I saw a blog post from my friend Paul Randal recently in which he recounted the books he’d read in...
2010-01-31
1,767 reads
Interview Questions On Sql Server -Part 2
1. What is the difference between the Union and Union All?
1) Union is used to select distinct data from the...
2010-01-31
2,001 reads
Interview Questions on sql server -Part-1
1. What is the Normalization?Normalization:-Normalization can be defined as the process of organization the data to reduce the redundant table...
2010-01-31
2,181 reads
Group by.....Having Clause
Group By:- Group By clauses is used to groups rows based on the distinct values of the specified columns.
The syntax...
2010-01-31
2,559 reads
Difference Between Having and Where Clause in Sql Server
Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there...
2010-01-31
11,963 reads
How to find duplicate values in a table
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a...
2010-01-31
4,046 reads
Sql Server View
Views:- View can be described as virtual table which derived its data from one or more than one table columns.It...
2010-01-31
1,727 reads
Stored Procedure to Get SQL Job Execution Status
Introduction
Ever need a programmatic way to figure out if a SQL Agent job is running? I did. After spending a...
2010-01-31
2,548 reads
Try Catch within an SSIS Script Tasks and Components
Using a Try/Catch/Finally within your Script Components and Script Tasks is just good coding practice. The thing you want to be able to do is push...
2010-01-30
2,591 reads
SEO my SQL Server Blog
I was going to spend today finishing off some SQL Server related blog posts, I currently have a list of...
2010-01-30
1,650 reads
Blogs
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...