SQL Server - How big is Big Data?

Who is online?  95 guests and 0 members
home  »  blogs  »  Ritesh Medhe  »  SQL Server - How big is Big Data?

SQL Server - How big is Big Data?

change text size: A A A

posted  8/16/2012 7:37:20 AM  by Ritesh Medhe -  Views: [1120] 

We have heard people talking about big data especially DWH folks.

Do we really know the definition of BIG Data? Majority of us would attribute big data solely to the size of data.

Well to know the real answer just check out the following link

 

http://mjfb-books.blogspot.in/2012/07/how-big-is-big-data.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+marcusborba+%28Business+Intelligence+News+by+Marcus+Borba%29

 

If you liked the posts, do like us on Facebook at http://www.FaceBook.com/SQLServerGeeks

tags : Big Data
  Rate This Blog Entry:  register  or  login

Author

riteshmedhe Ritesh Medhe (Member since: 3/31/2011 11:34:25 AM)
Ritesh Medhe is a Microsoft Certified DBA & a BI professional with over 8 years of experience. Expertise: Performance optimization & SQL Server Administration

View Ritesh Medhe 's profile

Comments (1)

8/20/2012 7:09:52 PM  said:

How is this a covering index ?

 

create nonclustered index IX_xtCheck on xtCheck(test1,test2)
WITH (drop_existing=on)
by

Leave a comment

Name:
  *  
Email:  (your email is kept secure)
 *  
Website:

example: "http://www.SQLServerGeeks.com"

 
Type the characters:
 *
 
   

Training on Microsoft Products & Technologies

Email Subscriptions

   Get the Most Recent Blogs in your inbox
Blogs RSS Feed

Ritesh Medhe's latest blog posts

  • SQL Server - How big is Big Data?
    8/16/2012 7:37:20 AM by Ritesh Medhe  - Views: 1121  - Comments: 1
    We have heard people talking about big data especially DWH folks. Do we really know the definition of BIG Data? Majority of us would attribute big data solely to the size of data. Well to know the rea...
  • SQL Server: Expose OLAP Cube over HTTP port 80
    2/28/2012 10:08:58 AM by Ritesh Medhe  - Views: 11431  - Comments: 3
    This white paper will navigate you through the process of exposing SSAS cubes over port 80 Prequisites : SSAS server must have IIS installed (if both the servers are different you might need to setup ...
  • SQL Server Monitoring - Automating SQL Server Health Checks (SQL Server 2005 & Above)
    2/20/2012 12:01:50 PM by Ritesh Medhe  - Views: 86252  - Comments: 3
    It's a known fact that an ideal Production DBA is like a parent to 100's of children. By children I mean database servers, and yes, they are like babies to DBAs. No matter how unpleasant your child is...
  • SQL Server Monitoring - Important SQL Server Monitroing Counters
    2/16/2012 12:26:02 PM by Ritesh Medhe  - Views: 16090  - Comments: 3
    Hello Guys, We all are aware that monitoring a database server for that matter any server is of prime importance in order to ensure business continuity. I will be talking only from database perspectiv...
  • SQL Server - Identify Unused Tables & Indexes
    1/9/2012 11:35:17 AM by Ritesh Medhe  - Views: 15607  - Comments: 8
    It often happens that DBA’s/Developers end up creating database objects(mostly tables) during development phase for various reasons like intermediate testing or backup . Such objects often end u...
  • SQL Server - Get TOP 5 Tables Consuming Maximum Space
    1/2/2012 7:39:51 AM by Ritesh Medhe  - Views: 47625  - Comments: 6
    I always say that database sizing is one of the prime tasks and concern for any DBA. As a DBA you should ensure that there is no single record claiming space in the databasefor no reason. DBA's should...
  • SQL Server - Identify Long Running Queries
    12/27/2011 12:35:02 PM by Ritesh Medhe  - Views: 63868  - Comments: 6
    It is always a big challenge to maintain application’s performance optimum. Increasing data on regular basis is often the cause for performance degrades. In most of the cases end users report th...
  • SQL Server: SQL-Getting rid of unused space in table
    12/24/2011 8:26:45 AM by Ritesh Medhe  - Views: 137725  - Comments: 6
    Scenario: Database sizing is one of the most critical tasks for any DBA. One of the DBA’s tasks is to also ensure optimum performance. Database/table size is one of the key factors impacting the...
Blogs RSS Feed

Latest community blog posts

  • Parse DBCC MemoryStatus using Powershell
    5/19/2013 10:58:46 AM by Ahmad Osama  - Views: 192  - Comments: 0
    A few days back I was resolving a memory issue which caused sql server to stop responding. I was able to figure out the issue by looking into DBCC MemoryStatus output. It was the full text search whic...
  • DB-Migrate v2: Powershell Module to Migrate Databases
    5/14/2013 8:11:24 PM by Ahmad Osama  - Views: 272  - Comments: 0
    This is an update to the DB-Migrate ( http://www.sqlservergeeks.com/blogs/AhmadOsama/personal/797/db-migrate-a-powershell-module-to-migrate-databases ) powershell module to migrate database between sq...
  • The TSQL Classes Stored Procedures: Transaction Handling
    5/12/2013 4:14:12 PM by Ahmad Osama  - Views: 278  - Comments: 0
    This blog is part of the series The TSQL Classes: Stored Procedure The links to previous post are given below. http://sqlservergeeks.com/blogs/AhmadOsama/personal/762/the-tsql-classes-stored-procedure...
  • Reporting With SSRS Part 1 -With Sample Report.
    5/9/2013 4:33:03 AM by Syed Asrar Ali  - Views: 165  - Comments: 0
    Reporting With SSRS Part 1 : In this serires of blogs, i will try to introduce you with some of the key features of the tool which will help you get on board to become a proficient report developer.If...
  • SQL Server – What is IDENTITY_INSERT?
    5/8/2013 2:31:43 PM by Piyush Bajaj  - Views: 1060  - Comments: 3
    Hi Folks, I am sure that all of you would be aware about the role of Identity column in a table, i.e., it is column which keeps on incrementing without supplying the value explicitly during insertion....
  • DB-Migrate: A PowerShell Module to Migrate Databases.
    5/5/2013 8:48:46 PM by Ahmad Osama  - Views: 775  - Comments: 0
    Recently I wrote powershell scripts to move databases, logins and SQL Agent Jobs between instances. Another one I wrote was to fix orphan users. I have now combined all of these different functions in...
  • SQL Server blogs from Ahmad Osama for the month of April
    5/3/2013 10:22:05 AM by Admin Admin  - Views: 351  - Comments: 0
    Hi SQL Geeks, Here are the blog posts by Ahmad Osama for the month of April. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at h...
  • The TSQL Classes Stored Procedures: Error Handling
    5/1/2013 9:05:11 PM by Ahmad Osama  - Views: 1138  - Comments: 0
    This blog is part of the series The TSQL Classes: Stored Procedure The link to previous post are given below. http://sqlservergeeks.com/blogs/AhmadOsama/personal/762/the-tsql-classes-stored-procedures...
  • Get free space in all files in an Instance
    4/8/2013 9:01:44 AM by Manohar Punna  - Views: 1671  - Comments: 1
    As DBAs we are always challenged of unexpected size growth of log or data files and need to shrink files based on available free space in each file. Most of the times we are stuck and do a lot of scri...
  • SQL Server: Using Powershell to Fix Orphan Users
    4/2/2013 7:05:50 PM by Ahmad Osama  - Views: 1736  - Comments: 0
    One of the major migration activities is to fix orphan users. Though, it can be easily fixed by sp_change_users_login procedure, however what if you need to do this for multiple servers. A powershell ...
  • The TSQL Classes Stored Procedures: Parameter sniffing
    4/1/2013 10:55:43 PM by Ahmad Osama  - Views: 2443  - Comments: 3
    This blog is part of the series The TSQL Classes: Stored Procedure. http://www.sqlservergeeks.com/blogs/AhmadOsama/personal/764/the-tsql-classes-stored-procedures-nested-proc-recursion-and-plan-cachin...