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

Latest Blog Posts

I’m A Friend Of Red Gate For 2015

I was excited to learn this week that I’ve been chosen as a participant in the Friends of Red Gate program for 2015. For those of you who are not SQL folk, you can stop reading now – Red Gate is a company who makes top-shelf products for working with… Read more

0 comments, 85 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 23 January 2015

Friday Followup For January 23, 2015

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

  • Building (for FREE) a Virtual Server for SQL Demos
  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed…

Read more

0 comments, 90 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 23 January 2015

SQLPort’s new image

After almost 5 years of existence, SQLPort (Portuguese PASS Chapter in Lisbon) is kicking of 2015 with a renewed image and with a lot of new projects that we are targeting to develop in the future. For years we have…

Read more

2 comments, 117 reads

Posted in Niko's blog on 22 January 2015

SQL- Querying XML attributes from XML Column

Read XML column attributes in to two columns DimType and Dimvalue  from the below example also retrieve the data matching values[DimTypes (WIDTH or Height)].

‘<dimensions>

<dimension name=”width”  value=”12.77″/>

<dimension name=”height”  value=”0.14″/>

<dimension name=”depth”      value=”12.92″/>

</dimenstions>’

Download SQL :-  https://gallery.technet.microsoft.com/SQL-Querying-XML-f700bbb0

 SQL:-

DECLARE @xml XML
SELECT @xml = 
'<dimensions>
  <dimension…

Read more

0 comments, 4,859 reads

Posted in PowerSQL By Prashanth Jayaram on 22 January 2015

Looking Out for Others Helps You Lead


I'm sitting on a plane. I'm in an exit row, still a big guy in a little seat. I go to sit down and notice the seat to my left has water on the seat. Not so deep that it is a puddle. 5 to 10 big drops. Enough that…

Read more

0 comments, 96 reads

Posted in SQLBalls on 22 January 2015

Excel Apps – Not Quite Ready for Primetime

While this is not a regular Excel tip, but it is about Excel. In my Excel BI Tips series, I am always looking for ways to build Excel dashboards or do BI work with Excel that will help everyone. In this case, I am going to discuss a new feature… Read more

0 comments, 156 reads

Posted in DataOnWheels on 22 January 2015

Exam Prep 70-463: Data Flow Destination Adapters

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

2 comments, 5,131 reads

Posted in Cleveland DBA on 22 January 2015

How to install standalone SQL Server 2012 instance ?

Steps to install standalone SQL Server 2012 instance

1) Start the setup > Go to Installation from Left > Click on 1st option of New SQL Server standalone edition from right

2) Click Ok to cont., In case of any failure, you need to fix that first

3) Enter Product… Read more

0 comments, 118 reads

Posted in MSSQLFUN on 22 January 2015

Advanced SSIS Training in Dallas

I’m very excited to offer a new course entitled “Advanced SSIS” in the Dallas area this spring. My friend and colleague Andy Leonard and I will be delivering this new 3-day course March 9-11, 2015 at the Microsoft offices in Irving, Texas. This course is intended for… Read more

0 comments, 98 reads

Posted in Tim Mitchell on 21 January 2015

Statistics Parsing

Never really enjoyed reading through the statistics IO results, as it makes it hard to easily guage total impact when you have a long list of tables.

A friend referred me to: http://www.statisticsparser.com/

This site is great! However, I really don't like manually copying and pasting the results each time.… Read more

0 comments, 4,361 reads

Posted in BIT Barbarian on 21 January 2015

Your tech lab just changed forever

The VMware Users Group VMUG just announced a partnership with VMware, called the EVALExperience, to offer VMware technology pre-production 365-day licenses as part of the VMUG yearly subscription! It’s now included in the $200 annual VMUG Advantage Subscription fee! WOW!

Your tech lab can now include with the… Read more

0 comments, 114 reads

Posted in Technobabble by Klee from @kleegeek on 21 January 2015

Constraint names, Say NO to the default

Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it makes no difference in terms of how things run but it does make it a bit of a pain when you need to code with it. Say dropping the… Read more

10 comments, 1,166 reads

Posted in SQLStudies on 21 January 2015

The Data Loading Performance Presentation

This Monday, at SQLSaturday Israel, I presented my new session, “The Data Loading Performance Presentation”.

I worked on the session a lot, and delivering it was tons of fun.

The session talks about the ways to load big amounts of data fast, and about the enemies that can make… Read more

0 comments, 124 reads

Posted in Matan Yungman on 21 January 2015

Outlier Detection with SQL Server, part 3.3: The Limitations of the Tietjen-Moore Test

By Steve Bolton

…………The Tietjen-Moore test may have the coolest-soundest name of any of the outlier detection methods I’ll be surveying haphazardly in this amateur series of mistutorials, yet it suffers from some debilitating limitations that may render it among the least useful for SQL Server DBAs. It is… Read more

0 comments, 113 reads

Posted in Multidimensional Mayhem on 20 January 2015

SQL Script to find the list of all the jobs failed yesterday

One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below SQL Script can be used to find out all the jobs which are failed yesterday.

SELECT DISTINCT
CAST(CONVERT(datetime,CAST(run_date AS char(8)),101) AS char(11)) AS 'Failure Date',
SUBSTRING(T2.name,1,40) AS 'Job Name',
T1.step_id…

Read more

0 comments, 1,368 reads

Posted in Vivek's SQL Notes on 20 January 2015

SQL Script to search stored procedures containing a given text

Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used to find out the list of all the stored procedures which contains a  particular given text as input.

SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%Given text%'

Read more

0 comments, 107 reads

Posted in Vivek's SQL Notes on 20 January 2015

SQL Script to find the tables created from a given date

Below is the SQL query which can be used to find out the tables which are created or modified on or from a given date.

SELECT
        [name] as Tablename
       ,create_date
       ,modify_date
FROM
        sys.tables where cast(create_date as…

Read more

0 comments, 187 reads

Posted in Vivek's SQL Notes on 20 January 2015

Excel BI Tip #17: Using the Timeline Filter

 

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to… Read more

0 comments, 3,730 reads

Posted in DataOnWheels on 20 January 2015

SQL Script to find the databases size

Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used to find out the size of all the databases created on the server. 

;WITH DBSize (SqlServerInstanceName, DatabaseName, DatabaseSize, DBLogSize, TotalDBSize)
AS
(
  SELECT      @@SERVERNAME SqlServerInstanceName,
 …

Read more

0 comments, 102 reads

Posted in Vivek's SQL Notes on 20 January 2015

Windows policy Lock Pages in Memory option and SQL Server instance in VM

As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in physical memory, preventing the Windows operating system from paging out a significant amount of data from physical memory to virtual memory on disk. This Windows policy is disabled… Read more

1 comments, 499 reads

Posted in Basit's SQL Server Tips on 20 January 2015

Newer posts

Older posts