<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,169 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,684 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,364 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
|
2,053 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,313 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
|
3,045 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,353 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
|
2,000 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,858 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,790 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,668 reads
Browse all
Question of the Day
INSERT
By
Kapil Singh
2013/05/17
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,111 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
571
640
SSChasing Mays
2.
Aadhar Joshi
421
1044
Ten Centuries
3.
karthicksurendran
408
408
SSC-Addicted
4.
Guy Drouin
389
942
SSC Eights!
5.
Lynn Pettis
325
21589
SSChampion
Show more
Latest forum posts
Assigning categories to values 1
By
Alex Fekken
|
May 19, 2013
Posted to
Discuss content posted by Hugo Kornelis
Intelisense is not working !!! Even After trying everything ...
By
Shadab Shah
|
May 19, 2013
Posted to
T-SQL (SS2K8)
How to select max based on condition.
By
surindersinghthakur
|
May 19, 2013
Posted to
SQL Server 2008 - General
Moving System Databases
By
UncleBoris
|
May 19, 2013
Posted to
SQL Server 2008 Administration
Are the posted questions getting worse?
By
SQLRNNR
|
May 19, 2013
Posted to
Anything that is NOT about SQL!
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
