SQL Server

SQL Server Community

SQL Server Blogs

prashanthjayaram
Follow /26 Dec 2014 at 9:35pm / SQL Server

T-SQL – How to Find Number of Words in a Given String

TSQL: To find number of words in a given string DECLARE @DemoTable Table (Col varchar(500)); INSERT INTO @DemoTable (Col)VALUES ('JOHN M SMITH ABC COMPANY') SELECT col, len(Col) - len(replace(col, ' ', '')) + 1 No_Of_Words...
24 0 /
prashanthjayaram
Follow /26 Dec 2014 at 5:48pm / SQL Server

Capturing Database(s) and Table Usage stats – sp_spaceused simulation using DMVs

For more Information refer  Technet Article Introduction sp_spaceused is one of the system stored procedure used frequently by many DBA’s that reveals amount of space used by database/tables. This procedure can be executed either by passing parameters...
36 0 /
Kevin Kline
Follow /26 Dec 2014 at 5:33pm / SQL Server

Minimizing Interruptions to Stay “In the Zone”

Have you ever been really focused on solving a problem? So focused that you tuned out the rest of the world around you? A monkey clanging cymbals in the cube next to yours wouldn’t bother you, you are so focused. Some IT professionals call this...
25 0 /
Jason Brimhall
Follow /26 Dec 2014 at 5:18pm / SQL Server

Happy Holidays

Quick and simple for today.  Happy Holidays to you!   Related Posts: December Recap SQL 2012 has Launched Always Waiting, Waiting Waiting Finally, it has happened… On the Seventh Day…
39 0 /
Jason Strate
Follow /26 Dec 2014 at 4:00pm / SQL Server

Reblog: December 19 to December 25

Photo credit – JStove Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no...
33 0 /
Tracy McKibben
Follow /26 Dec 2014 at 1:00pm / SQL Server

Friday Followup For December 26, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week Little Java Boy The Value of Writing Good Building...
45 0 /
derekewilson
Follow /26 Dec 2014 at 12:00pm / SQL Server

T-SQL COALESCE Example

T-SQL COALESCE SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your expression.  For example, I want to return the products in the AdventureWorks sample database and show the SellEndDate if it exists...
37 0 /
NickyvV
Follow /26 Dec 2014 at 10:31am / SQL Server

MCSA SQL Server 2012 and Best Wishes

I can finally announce that this Wednesday, just before Christmas, I nailed the 70-463 exam. About 3 weeks ago I already passed 70-462, so I am now qualified as MCSA SQL Server 2012, whohoo! :-) And now on to my MCSE BI.. But not before 2015 starts.....
27 0 /
Rohit Garg
Follow /26 Dec 2014 at 3:44am / SQL Server

Cumulative Update – 5 for SQL Server 2014 RTM Is Now Available !

The 5th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 5 contains all the hotfixes released since the initial release of SQL Server 2014 RTM. Those who are facing severe...
38 0 /
Thomas LaRock
Follow /24 Dec 2014 at 7:06pm / SQL Server

5 Ways To Avoid Having To Write a Christmas Blog Post

Yes, it’s that time of year again, when every blogger takes time out of the schedule to produce a post about Christmas or whatever Happy Holiday you celebrate. Truth be told I spent the past two weeks trying to think of something I could write about...
47 0 /
Derik Hammer
Follow /24 Dec 2014 at 2:00pm / SQL Server

Failing over AlwaysOn Availability Groups

Merry Christmas Eve! A few weeks ago I posted on Availability Group fail-over tests with PowerShell . That post covered the basics of how to check the Availability Group’s state and perform the commands for conducting a zero data loss fail over...
51 0 /
prashanthjayaram
Follow /23 Dec 2014 at 9:20pm / SQL Server

SQL – How to Find Missing Sequence in a table

Problem statement:-  A  table with identity column have ‘n’ rows  in that few rows are deleted. How to find  which rows are deleted? Solution:- create table test (a int); insert into test values (7001); insert into test values (7002...
57 0 /
Thomas LaRock
Follow /23 Dec 2014 at 8:49pm / SQL Server

How To Better Break Down Information Silos

It all started with a simple question. “What’s a table?,” my nine-year-old daughter asked me during a session I was giving at SQL Saturday #184 last year. Now, being my daughter, I know that she has the innate ability to ask questions just for the sake...
62 0 /
sqlkris
Follow /23 Dec 2014 at 1:00pm / SQL Server

What is the Difference between Truncate and Delete in SQL Server?

In SQL Server there are a couple a ways you can delete rows from a table.   You can use either the TRUNCATE or DELETE command.  Though the end result of both commands is the same, there are very important differences you should know about. The TRUNCATE...
57 0 /
SQLDBAWithABeard
Follow /23 Dec 2014 at 12:04pm / SQL Server

Twas 2 Days Before Xmas or Thank you SQLFamily

Twas 2 days before Xmas & all through the office, not a creature was stirring not even old Maurice. With merriment going on outside of his window There sat a bearded DBA without much to do No changes can be made through the holiday season We...
178 0 /