<a href="//g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
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
<a href="//g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 1,777,834 DBAs, developers and SQL Server users
Headlines today
January 28, 2015
Stairway to Advanced T-SQL Level 2: Using the APPLY Operator
The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences between these two formats, and show you examples of how each of these formats work.
Read more...
By
Gregory Larsen
2015/01/28
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
3,718 reads
Free eBook: Performance Tuning with SQL Server Dynamic Management Views
Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.
Read more...
By
Additional Articles
2015/01/28 (first published: 2013/08/21)
|
Source:
Red-Gate
|
Category:
performance tuning
Rating:
Rate this
|
Briefcase
|
46,104 reads
Why Developers Need to Understand Execution Plans
If you can examine and understand execution plans, you can achieve better understanding of the database system and you will write better database code. Grant Fritchey shows you how.
Read more...
By
Additional Articles
2015/01/28
|
Source:
SimpleTalk
|
Category:
execution plan
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,923 reads
Show more
Previous headlines
Data Mining Part 23: Security
In this chapter we will talk about security recommendations for SQL Server Data Mining.
Read more...
By
Daniel Calbimonte
2015/01/27
|
Source:
SQLServerCentral.com
|
Category:
roles
Rating:
|
Discuss
|
Briefcase
|
1,277 reads
Grant Fritchey Reviews Minion Reindex
Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes.
Read more...
By
Grant Fritchey
2015/01/27
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
953 reads
Finding Encrypted Data in a SQL Server Database
The easiest way to determine if there is encrypted data in a database is to get that information from whoever wrote the application. Aside from that, there are a few things you can look for which would suggest that you have encrypted data in a given database.
Read more...
By
Additional Articles
2015/01/27
|
Source:
MSSQLTips.com
|
Category:
encryption
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,631 reads
Selecting from sub-queries as tables
Using sub-queries as tables only requires an alias
Read more...
By
Ben Kubicek
2015/01/26
|
Source:
SQLServerCentral.com
|
Category:
sub-queries
Rating:
|
Discuss
|
Briefcase
|
8,753 reads
SQL Prompt Tip #7 - Begin End Highlighting
This SQL Prompt tip shows you how code highlighting makes it easier to find which items match up with each other.
Read more...
By
Steve Jones
2015/01/26
|
Source:
SQLServerCentral.com
|
Category:
sql prompt
Rating:
|
Discuss
|
Briefcase
|
1,690 reads
Discrete and Continuous Data in SQL
Not all data is discrete; some data types represent a continuum. In SQL, we have to approximate them and live with the special problems of handling continuous data. We need to understand the problems associated with continuous data types, when these will happen, and how it affects constraints and the results of queries. Joe Celko explains.
Read more...
By
Additional Articles
2015/01/26
|
Source:
SimpleTalk
|
Category:
data
Rating:
(not yet rated)
Rate this
|
Briefcase
|
5,340 reads
Removing Duplicates
How to remove identify and remove duplicate data from your tables
Read more...
By
Sioban Krzywicki
2015/01/23 (first published: 2013/10/08)
|
Source:
SQLServerCentral.com
|
Category:
duplicate data
Rating:
|
Discuss
|
Briefcase
|
26,491 reads
From the SQLServerCentral Blogs
Statistics Parsing
Never really enjoyed reading through the statistics IO results, as it makes it hard to easily guage total impact when...
Read more...
By
g00p3
2015/01/28
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,106 reads
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...
Read more...
By
DataOnWheels
2015/01/28
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,295 reads
Browse all
Question of the Day
EXCEPT
By
Steve Jones
2015/01/28
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
668 reads
How many rows are returned?
CREATE TABLE sales
(
CustomerID int
,Salesyear char(4)
, complete tinyint
, amount int
);
GO
INSERT INTO dbo.sales
( CustomerID
, Salesyear
, complete
, amount
)
VALUES
( 1, '2013', 1, 100)
, ( 1, '2013', 1, 200)
, ( 1, '2014',...
Read more...
Show more
Top Members (last 30 days)
#
Name
Score
Level
30 days
All-time
1.
akgshankar
627
833
SSC Eights!
2.
vecerda
513
618
SSChasing Mays
3.
Jeff Moden
453
36312
SSC-Dedicated
4.
RK Mandava
366
2333
SSCrazy
5.
patricklambin
361
1975
SSCommitted
Show more
Latest forum posts
EXCEPT
By
RK Mandava
|
Jan 28, 2015
Posted to
Discuss Content Posted by Steve Jones
2 SQL FCIs and 1 HAG
By
S. Kusen
|
Jan 28, 2015
Posted to
SQL 2012 - General
Normal Data
By
Eric M Russell
|
Jan 28, 2015
Posted to
Editorials
Gui view from a differnet database ???
By
Sean Lange
|
Jan 28, 2015
Posted to
SQL Server 2008 - General
Need help getting XML data out of SQL table
By
kevin.young 1284
|
Jan 28, 2015
Posted to
XML
Copyright © 2002-2015 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
