<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://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="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://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,632,010 DBAs, developers and SQL Server users
Show more
Previous headlines
Powershell Database Backup Script
Learn how to write a script for regular database backups using Powershell and SMO.
Read more...
By
Jimmy Atsaves
2013/05/17 (first published: 2011/01/05)
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
16,342 reads
Raw Materials - Beyond Global
There's more than one way to be green.
Read more...
By
Larry Gonick
2013/05/17 (first published: 2010/09/22)
|
Source:
SQLServerCentral.com
|
Category:
raw materials
Rating:
|
Discuss
|
Briefcase
|
10,288 reads
Getting Started Formatting SSRS Reports
Once you've prepared an SSRS report, it needs formatting to get it ready for the people who need to read it. This tip covers the basics of formatting SSRS Reports.
Read more...
By
Additional Articles
2013/05/17
|
Source:
SQL Server Performance
|
Category:
ssrs
Rating:
Rate this
|
Briefcase
|
1,756 reads
How to Change the SQL Server Name after Renaming the Windows Host
This article shows how to change a SQL Server name after changing the Windows machine name.
Read more...
By
Shashank Srivastava
2013/05/16
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
5,154 reads
Getting Started Testing Databases with tSQLt
There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is written in TSQL and is simple for a database developer to set up and use. It doesn't get in the way. Rob Sheldon shows you how to get started.
Read more...
By
Additional Articles
2013/05/16
|
Source:
SimpleTalk
|
Category:
tsqlt
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,811 reads
Using XML from data variable option in SSIS
Learn how you can manipulat XML documents solely in memory. No file required.
Read more...
By
Cindy Conway
2013/05/15
|
Source:
SQLServerCentral.com
|
Category:
sql server
Rating:
|
Discuss
|
Briefcase
|
3,286 reads
SQL Saturday #220 - Atlanta
A free day of training this weekend in Atlanta, GA.
Read more...
By
Press Release
2013/05/15
|
Source:
SQLServerCentral.com
|
Category:
sql saturday
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,655 reads
Forwarding Pointers in Heaps
When no clustered index is defined on a table, that table is said to be a Heap. Heaps are not ideal when it comes to performance but there are lots of instances where you have heaps.
Read more...
By
Additional Articles
2013/05/15
|
Source:
SQL Server Performance
|
Category:
heaps
Rating:
Rate this
|
Briefcase
|
1,757 reads
Converting Large Object Data Types
Eliminate pesky legacy TEXT, NTEXT and IMAGE data types with this handy script.
Read more...
By
Othman Hack
2013/05/14
|
Source:
SQLServerCentral.com
|
Category:
data types
Rating:
|
Discuss
|
Briefcase
|
3,739 reads
SQL Saturday #212 - Redmond
A free day of training in Redmond, WA this weekend on May 18, 2013.
Read more...
By
Press Release
2013/05/14
|
Source:
SQLServerCentral.com
|
Category:
sql saturday
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,381 reads
Browse all
Question of the Day
INSERT
By
Kapil Singh
2013/05/17
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,010 reads
CREATE TABLE [dbo].[test]
(
[ID] [int] IDENTITY(1,1) NOT NULL,
[PK_col] [int] PRIMARY KEY,
[Col1] [int] NULL,
[Col2] [int] NULL,
[Col3] AS ([col1]+[col2])
)
SELECT *
INTO TEST1
FROM TEST
---Statement1
INSERT INTO test
VALUES (1,2,3)
---Statement2
INSERT INTO TEST1
VALUES (1,2,3)
...
Read more...
Show more
Top Members (last 30 days)
#
Name
Score
Level
30 days
All-time
1.
chihaia_ciprian
622
640
SSChasing Mays
2.
Aadhar Joshi
421
1044
Ten Centuries
3.
karthicksurendran
408
408
SSC-Addicted
4.
Guy Drouin
392
942
SSC Eights!
5.
Sean Lange
363
8547
SSCrazy Eights
Show more
Latest forum posts
Help with DBCC CHECKDB output
By
Dimbulbz
|
May 18, 2013
Posted to
Data Corruption (SS2K8 / SS2K8 R2)
Best way to find certain records.
By
New Person
|
May 18, 2013
Posted to
SQL Server 2008 - General
Assigning categories to values 1
By
L' Eomot Inversé
|
May 18, 2013
Posted to
Discuss content posted by Hugo Kornelis
help with best practice for merging 2 sql databases
By
GilaMonster
|
May 18, 2013
Posted to
Backups
Which query to be used if IO Stats are different but actual ...
By
GilaMonster
|
May 18, 2013
Posted to
SQL Server 2012 - T-SQL
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
