<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>
Content with tag
SQL
Items 1 to 11 of 11
Rendering PDFs Natively in SQL
How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.
Read more...
By
David Rueter
2013/05/08
|
Source:
SQLServerCentral.com
|
Category:
pdf
Rating:
|
Discuss
|
Briefcase
|
13,733 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:
sql
Rating:
|
Discuss
|
Briefcase
|
2,847 reads
Manipulate Horizontal Hierarchy with UNPIVOT
Convert Horizontal Hierarchy to vertical Hierarchy.
Read more...
By
Bernabe Diaz
2012/12/20
|
Source:
SQLServerCentral.com
|
Category:
sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
729 reads
Scripting CREATE INDEX Statements Automatically From Your Tables
Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.
Read more...
By
Derek Colley
2012/11/27
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
1,229 reads
Routine Dependency Visualizer
This article contains a T-SQL script that can show you the dependency of all objects in your SQL Server database.
Read more...
By
Angel Rapallo
2012/10/30
|
Source:
SQLServerCentral.com
|
Category:
sql
Rating:
|
Discuss
|
Briefcase
|
3,872 reads
CPU and Scheduler Performance Monitoring using SQL Server and Excel
This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.
Read more...
By
Derek Colley
2012/10/04
|
Source:
SQLServerCentral.com
|
Category:
sql
Rating:
|
Discuss
|
Briefcase
|
6,785 reads
Script to get an ordered list of all stored procedures with parameters
Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.
Read more...
By
Derek Colley
2012/08/14
|
Source:
SQLServerCentral.com
|
Category:
sql
Rating:
|
Discuss
|
Briefcase
|
1,873 reads
Delete old backup
Delete old backup files on a prespecified folder.
Read more...
By
Matimba Maluleke
2012/07/03
|
Source:
SQLServerCentral.com
|
Category:
sql
Rating:
|
Discuss
|
Briefcase
|
1,068 reads
Change Tracking - 2008
Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes.
Read more...
By
Nitesh Dedhia
2012/06/18
|
Source:
SQLServerCentral.com
|
Category:
change tracking
Rating:
|
Discuss
|
Briefcase
|
7,038 reads
10 tips on converting MS SQL queries to MySQL
The syntax of SQL queries in MS SQL and MySQL are similar but not identical. This article discovers 10 most popular differences between MS SQL and MySQL syntax.
Read more...
By
Oleg Fedorov
2012/06/01
|
Source:
SQLServerCentral.com
|
Category:
sql
Rating:
|
Discuss
|
Briefcase
|
4,990 reads
How to query dBase .dbf from SQL 2012 64-bit
Query dBase .dbf Files From SQL 2012 64-bit.
Read more...
By
James Ochsenfeld
2012/05/09
|
Source:
SQLServerCentral.com
|
Category:
sql
Rating:
|
Discuss
|
Briefcase
|
753 reads
Items 1 to 11 of 11
Tags
excel
(2)
reporting services (ssrs)
(2)
ace
(1)
advantage
(1)
affinity
(1)
assembly
(1)
automation
(1)
backup / restore
(1)
change tracking
(1)
clr
(1)
cpu
(1)
create index
(1)
data dictionary
(1)
data warehouse
(1)
dbase
(1)
dependency
(1)
fox
(1)
graphs
(1)
indexing
(1)
internals
(1)
list
(1)
map
(1)
monitoring
(1)
mysql
(1)
new feature of sql server 2008
(1)
nitesh dedhia
(1)
parameter
(1)
pdf
(1)
performance tuning
(1)
pro
(1)
render
(1)
routine
(1)
schedulers
(1)
scripting
(1)
sp_sproc_columns
(1)
sql server
(1)
sql server 2008
(1)
sqlclr
(1)
stored procedure
(1)
stream
(1)
sybase
(1)
syntax
(1)
sys.dm_os_ring_buffers
(1)
sys.dm_os_schedulers
(1)
sys.dm_os_sysinfo
(1)
udf
(1)
visualizer
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
