Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: December 2013

Day 5 – Peer Identity

This is the fifth installment in the 12 day series for SQL tidbits during this holiday season.

Previous articles in this mini-series on quick tidbits:

  1. SQL Sat LV announcement
  2. Burning Time
  3. Reviewing Peers
  4. Broken Broker

In the digital age it seems we are constantly flooded with articles about identity crises.… Read more

1 comments, 122 reads

Posted in SQL RNNR on 29 December 2013

Deleting Duplicate rows using CTE

Many times we caught in a situation where we have a table where there is no primary or unique column defined in it and rows with duplicate data inserted in the table. In this example I will tries to show how to delete the duplicate rows using CTE.

Suppose we…

Read more

0 comments, 534 reads

Posted in Vivek's SQL Notes on 29 December 2013

Day 4 – Broken Broker

This is the fourth installment in the 12 day series for SQL tidbits during this holiday season.

Previous articles in this mini-series on quick tidbits:

  1. SQL Sat LV announcement
  2. Burning Time
  3. Reviewing Peers

Brokers

 

 

 

 

On a recent opportunity to restore a database for a client, I… Read more

0 comments, 107 reads

Posted in SQL RNNR on 28 December 2013

Answer -Question of the Week - 25/12/2013- Question 1


Question:- Suppose we have a table says tbl_students whose structure is given below:-

Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))

Suppose it contains the following data:-

Studentid  Studentname
1               Vivek Johari
2               Chandra Singh
4…

Read more

1 comments, 133 reads

Posted in Vivek's SQL Notes on 28 December 2013

Question of the Week - 28/12/2013 - Question 2

Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".
It contains 10 rows. First 5 rows contains "Vivek Johari" and the next 5 rows contains "Abhinav Golwalkar"

tbl_charactername
---------------------
Vivek Johari
Vivek Johari
Vivek Johari
Vivek Johari
Vivek Johari
Abhinav Golwalkar
Abhinav Golwalkar
Abhinav Golwalkar

Read more

9 comments, 95 reads

Posted in Vivek's SQL Notes on 28 December 2013

The Effective Cell Phone

I’ve written a bit about phones recently as I’ve experienced the switch back to iOS from Android. There are a few other posts in this series:

I wanted to stop and take a moment and think about design… Read more

0 comments, 178 reads

Posted in The Voice of the DBA on 27 December 2013

Reblog: December 20 to December 26

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question.  It’s that whole “cha-ching” – buried treasure! feeling.  That’s kind of the aim of this blog post.  To provide… Read more

0 comments, 146 reads

Posted in StrateSQL on 27 December 2013

When DMVs Cost Me My Job

Back in early 2006, I was still working at my first ever DBA job. I had only been a DBA for a little less than 3 years, but I felt like I knew a lot. I spent every night on the forums helping people with issues as a way of…

Read more

Friday Followup For December 27, 2013

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

Read more

0 comments, 112 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 27 December 2013

Day 3 – Reviewing Peers

This is the third installment in the 12 day series for SQL tidbits during this holiday season.

Previous articles in this mini-series on quick tidbits:

  1. SQL Sat LV announcement
  2. Burning Time

Remember back in the day when Napster was really popular?  I’m sure it is still popular now – just… Read more

1 comments, 288 reads

Posted in SQL RNNR on 27 December 2013

MDX #35 – Properties() function with TYPED flag

 

Reader Query

My publisher recently forwarded me a question from a reader about the “Using the PROPERTIES() function to retrieve data from attribute relationships” section in Chapter 1 of the book “MDX with SSAS 2012 Cookbook”.

“The following code seems to always return true for [Is Numeric],… Read more

0 comments, 117 reads

Posted in Sherry Li's BI Corner on 27 December 2013

SQL Saturdays Coming Up!

Don't forget! Monday is the final give away! I will be giving away a free copy of the Professional SQL Server 2012 Internals and Troubleshooting. Any previous winner can win this as well. If you live outside of the continental US, I will send you a code for a…

Read more

0 comments, 121 reads

Posted in DBA On The Go on 27 December 2013

Last Weeks Top “Reading” Links #63

It’s Thursday and about time for this week’s weekly link round-up.  Since it’s the holidays, I didn’t feel like putting this together earlier this week, but figured I shouldn’t skip it so here we go.  Also, if you follow me on twitter (@StrateSQL), you’ll know that throughout most… Read more

0 comments, 219 reads

Posted in StrateSQL on 26 December 2013

Entity Data Modeling with Visual Studio

While there are a lot of tools out there for data modeling, there is one option that is free if you have Visual Studio.  It’s called the Entity Data Model Designer.  It works well if you need a quick-and-dirty way to create a logical model of tables and have the… Read more

4 comments, 4,199 reads

Posted in James Serra's Blog on 26 December 2013

Review of Change to PASS Bylaws

As required, the Board has posted proposed changes to the bylaws for review by the members. The changes are fairly straight forward, reducing the number of Board seats by 2 – a change driven by CA choosing to relinquish their two seats. I like seeing a small and very specific… Read more

0 comments, 119 reads

Posted in SQLAndy on 26 December 2013

Supporting Wikipedia & Other Organizations

I just sent Wikipedia five bucks. As someone who uses Wikipedia and finds it useful, I’m willing to donate in the hope that it grows, improves, and generally does better than the year before. I don’t know or think that it’s perfectly run or that they spend every dollar perfectly.… Read more

3 comments, 769 reads

Posted in SQLAndy on 26 December 2013

12 Days of Christmas 2013 Day 2

This is the second installment in the 12 day series for SQL tidbits during this holiday season.

Previous articles in this mini-series on quick tidbits:

  1. SQL Sat LV announcement

Recently I was able to observe an interesting exchange between a couple of key people at a client.  That exchange gave… Read more

3 comments, 150 reads

Posted in SQL RNNR on 26 December 2013

Powershell Backups and Post Frequency Change

It's been a good run doing a post every day. I'm scaling it back a bit. I liked getting these 36 posts out one a week day for some time now. I'm going to scale back. I"m not sure yet if I'll go down to one or two a week.…

Read more

0 comments, 178 reads

Posted in DBA On The Go on 26 December 2013

12 Days of Christmas 2013 Day 1

Last year I did a mini-series themed around the 12 Days of Christmas.  I am going to do a similar series this year.  Over the next 12 days, I will share short tidbits on an array of topics.  The tidbit may be a tip to help with SQL Server,… Read more

10 comments, 175 reads

Posted in SQL RNNR on 25 December 2013

Christmas Day Winner and RDC Clients: Day 13

Finally we'll see who won the final training prize! The winner is Komal! Merry Christmas and Happy Holidays to everyone! The free book post is going up Dec 30th and the free book winner will be announced New Years day! As always, I will need an E-Mail to do the drawing and…

Read more

0 comments, 142 reads

Posted in DBA On The Go on 25 December 2013

Newer posts

Older posts