Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/04/01 to 2013/04/08

A Simple Formula to Calculate the ISO Week Number

He admits it wasn't his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you're "stuck" with SQL Server 2005 or less, you're going to like this a whole lot!  Read more...
By Jeff Moden 2013/04/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,609 reads

SQL Server JOIN Hints

You, as a SQL Server data professional, are looking for ways to improve your queries. You've done the usual - avoided cursors and loops, used locks effectively, examined execution plans - what else can you tweak? Check out this tip to learn more.  Read more...
By Additional Articles 2013/04/08 | Source: MSSQLTips.com | Category: join
Rating: (not yet rated)  Rate this |   Briefcase | 5,923 reads

SQL Saturday #189 - Costa Rica

Join us at SQL Saturday Costa Rica on April 13, 2013 for a day of SQL Server Training and Networking.  Read more...
By Press Release 2013/04/08 | Source: SQLServerCentral.com | Category: sql saturday
Rating:  Rate this |   Briefcase | 1,399 reads

New Custom Metric: Long Running Job

SQL Monitor’s Job duration unusual alert is a powerful tool for keeping track of most jobs in your SQL Server environment. It works by comparing the running time of any job instance against the median for that job, and identifying when a variation in the job duration could hint at a performance problem. However, if your environment contains big jobs whose durations vary by several orders of magnitudes, it can be tricky to specify what kind of variation is expected and what would be unusual. For these cases, it is possible to go beyond the functionality of the built-in alert with a custom metric.  Read more...
By Press Release 2013/04/05 | Source: Red-Gate | Category: red gate software
Rating: (not yet rated)  Rate this |   Briefcase | 2,118 reads

Stairway to SQL Server Indexes: Level 1, Introduction to Indexes

Indexes are the database objects that enable SQL Server to satisfy each data access request from a client application with the minimum amount of effort, resulting in the maximum performance of individual requests while also reducing the impact of one request upon another. Prerequisites: Familiarity with the following relational database concepts: Table, row, primary key, foreign key  Read more...
By David Durant 2013/04/05 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 43,606 reads

Generating Sequence Numbers Using the Sequence Object

The new SQL Server 2012 Sequence Object can be used to generate unique numbers that can be automatically incremented based on an increment value. Greg Larsen discusses the different features of the sequence object and how you can use it to generate sequence numbers.  Read more...
By Additional Articles 2013/04/05 | Source: Database Journal | Category: sequence numbers
Rating: (not yet rated)  Rate this |   Briefcase | 2,496 reads

SQL Saturday #211 - Chicago

SQL Saturday is coming to Chicago, IL on April 13, 2013. Join us for a day of free SQL Server training and networking.  Read more...
By Press Release 2013/04/04 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,866 reads

Error logging with Bulk Insert

Bulk Insert statement has an important feature of error logging which is rarely used.  Read more...
By Mohammad Atif 2013/04/04 | Source: SQLServerCentral.com | Category: bulk insert
Rating: |  Discuss |   Briefcase | 4,921 reads

SQL Server 2012 Window Function Basics

For some time, Microsoft had a few window functions, but not the full set specified in the SQL 2003 standard. Now, in SQL Server 2012 we have the whole range, and extremely useful they are too. There's no longer an excuse to avoid them, particularly now you have Rob Sheldon's gentle introduction.  Read more...
By Additional Articles 2013/04/04 | Source: SimpleTalk | Category: sql server 2012
Rating:  Rate this |   Briefcase | 4,366 reads

A Hazard of Using the SQL Merge Statement

The SQL MERGE statement can make your DML querying more efficient but you need to take care or you may get burned  Read more...
By Dwain Camps 2013/04/03 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 13,901 reads

Join Reordering and Bushy Plans

Normally, the query Optimiser won't consider 'bushy' plans, where both operands to a join operator could be intermediate results from other joins. This means that it won't produce good query plans for some types of query. Hints, by themselves won't do it. More powerful magic is required.  Read more...
By Additional Articles 2013/04/03 | Source: SimpleTalk | Category: join ordering
Rating: (not yet rated)  Rate this |   Briefcase | 3,367 reads

Expand Your Skills at the PASS Business Analytics Conference

Join top business intelligence and analytics experts in Chicago April 10-12 for 60+ sessions on the best practices, prescriptive guidance, and strategic vision you need to get the most from your data. Use code BACSSC to save $250 today!  Read more...
By Press Release 2013/04/03 (first published: 2013/03/14) | Source: PASS | Category: bi
Rating: (not yet rated)  Rate this |   Briefcase | 6,414 reads

SQL Saturday #203 - Boston

Join us at SQL Saturday Boston on April 6th. SQL Saturday is a free training event for SQL Server Professionals and those wanting to learn more about SQL Server.  Read more...
By Press Release 2013/04/02 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated) |  Discuss |   Briefcase | 287 reads

Low Profile Architecture

The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month.   Read more...
By Igor Zaychik 2013/04/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,761 reads

Blocking SQL Server db_datareader, db_datawriter, and db_owner Permissions

n a database I currently support, the application makes use of db_datareader and db_datawriter to give permissions to the tables. In a different database, it's even worse as the application uses db_owner. We're adding new tables to both databases and we don't want the application to have access to these tables. How can I deal with the use of these three roles?  Read more...
By Additional Articles 2013/04/02 | Source: MSSQLTips.com | Category: db_datareader
Rating: (not yet rated)  Rate this |   Briefcase | 3,357 reads

Mo-SQL

If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed to – depending on your view or the product I suppose – make databases simpler, break out of the transaction database paradigm, scale out across hundreds of machines, make it easy to change the db design (or not require one). I think some of the problems no-sql tries to solve are real, others reflect a lack of awareness/training/tools on how and why relational databases could not just solve the problem, but solve it better.  Read more...
By Andy Warren 2013/04/01 | Source: Other | Category: blogs
Rating:  Rate this |   Briefcase | 3,452 reads

TSQL Pivot Rotations using only REPLACE

Pivoting SQL Server tables is always awkward, even with the PIVOT and UNPIVOT operators. If you want to get the job done without GROUP BY or PIVOT, here is a way to do it using only REPLACE.  Read more...
By Additional Articles 2013/04/01 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,953 reads

Throttle a Query in Mid-Execution

Resource Governor provides a great mechanism for throttling resources, but it doesn't always allow granular control. Read about this trace flag that allows you to dynamically alter the resource usage of a query.  Read more...
By Steve Jones 2013/04/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,504 reads