Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 1,449,297 DBAs, developers and SQL Server users
Headlines today
January 27, 2012
Stairway to Transaction Log Management in SQL Server, Level 5: Managing the Log in Full Recovery Mode
In FULL recovery mode it is possible to do a point-in-time restore of a database. It is thankfully a rare event. Tony explains what's involved
Read more...
By
Tony Davis
2012/01/27
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
3,763 reads
Solving the Running Total and Ordinal Rank Problems (Rewritten)
Revisiting his very popular article on the running total and ordinal rank problems, MVP Jeff Moden brings us a detailed analysis of how you might want to implement a solution in T-SQL.
Read more...
By
Jeff Moden
2012/01/27 (first published: 2009/11/10)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
21,227 reads
Cumulative Aggregates in SQL Server Reporting Services
In this tip, we will see how to build a report which shows the cumulative sales amount for the current month, current quarter (QTD) and current year (YTD) in a single crosstab (tablix) report, which makes it easy to compare the data.
Read more...
By
Additional Articles
2012/01/27
|
Source:
MSSQLTips.com
|
Category:
aggregates
Rating:
(not yet rated)
Rate this
|
Briefcase
|
817 reads
Show more
Previous headlines
Process Support Database Framework
Do you use or need a database process framework? Read on to see if this is something that might help you build better database software processes.
Read more...
By
Leo Peysakhovich
2012/01/26
|
Source:
SQLServerCentral.com
|
Category:
framework
Rating:
|
Discuss
|
Briefcase
|
2,582 reads
Raw Materials - Wake-up Call
A robot's reaction may be a little different from yours or mine.
Read more...
By
Larry Gonick
2012/01/26 (first published: 2010/08/04)
|
Source:
SQLServerCentral.com
|
Category:
raw materials
Rating:
|
Discuss
|
Briefcase
|
7,746 reads
Using XML to pass lists as parameters in SQL Server
Every so often, the question comes up on forums of how to pass a list as a parameter to a SQL procedure or function. Phil Factor provides some examples using XML, and tests them against other popular methods.
Read more...
By
Additional Articles
2012/01/26
|
Source:
SimpleTalk
|
Category:
xml
Rating:
Rate this
|
Briefcase
|
2,323 reads
Stairway to SQL Server Agent - Level 10: Using proxy accounts with your Jobs
Examines the proxy subsystem, which allows job steps to impersonate another user account in order to perform tasks as a user other than the SQL Server Agent service account. This is especially useful when you want jobs to run as lower privileged users of your SQL Server.
Read more...
By
Richard Waymire
2012/01/25
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
2,790 reads
Controlling Growth of an msdb Database
I recently encountered a situation where the drive hosting Sharepoint Databases in a Staging environment ran out of space. I logged onto the server and found that the msdb database has itself occupied 38 GB of the total disk space. Msdb database generally contain maintenance information for the database such as backups, log shipping and so on.
Read more...
By
Additional Articles
2012/01/25
|
Source:
SQL Server Performance
|
Category:
msdb
Rating:
Rate this
|
Briefcase
|
1,844 reads
Database Development Tasks Survey
We'd like to better understand the kinds of database related development tasks that you perform, so that we can ensure our tools are helping you to be more productive.
Read more...
By
Press Release
2012/01/25
|
Source:
Red-Gate
|
Category:
red gate software
Rating:
(not yet rated)
Rate this
|
Briefcase
|
747 reads
Learn about SQL Server 2012 in the desert
Come see Brad McGehee, Grant Fritchey, Steve Jones, and more SQL Server speakers at the SQL Server Connections conference in Las Vegas this spring. Get away from the cold on Mar 26, 2011 and learn about the new version of SQL Server.
Read more...
By
Press Release
2012/02/09 (first published: 2012/01/25)
|
Source:
SQLServerCentral.com
|
Category:
sql server connections
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,047 reads
From the SQLServerCentral Blogs
The Kind of DBA I Want to Be
The Kind of DBA I Want to Be Rokusaburo Michiba (Iron Chef Japanese) I was a big fan of the original Iron...
Read more...
By
2012/01/27
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
900 reads
Deadlock Monitoring
There are four different ways you can get information about deadlocks in your system. These are: traceflag 1204traceflag 1222trace eventsextended eventsFor...
Read more...
By
2012/01/27
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
982 reads
Browse all
Question of the Day
XML to Relational
By
Stewart Campbell
2012/01/27
|
Category:
xquery
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
793 reads
Consider the following XML variable:
We require the following result set from the above variable:
Which of the following queries will return the above-mentioned result set?
Read more...
Show more
Top Members (last 30 days)
#
Name
Score
Level
30 days
All-time
1.
Diane Fortin
2006
2006
SSCrazy
2.
the_macabros
891
1052
Ten Centuries
3.
GilaMonster
822
29979
SSChampion
4.
Gary Varga
548
2718
SSCrazy
5.
SQL Kiwi
542
9935
SSCrazy Eights
Show more
Latest forum posts
Converting datetime
By
Jeff Moden
|
Jan 27, 2012
Posted to
T-SQL (SS2K8)
Process Support Database Framework
By
Jon Saltzman
|
Jan 27, 2012
Posted to
Discuss Content Posted by Leo Peysakhovich
parrallelperiod caluclated member not correct when using Fis...
By
Don Shields-368041
|
Jan 27, 2012
Posted to
Analysis Services
Performance Tuning
By
LutzM
|
Jan 27, 2012
Posted to
SQL Server 2008 - General
SQL Server Performance
By
Lee Crain
|
Jan 27, 2012
Posted to
SQL Server 2008 Administration
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.