Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Miscellaneous, T-SQL Rss

<< Newer    Items 21 to 40 of 574    Older >>
 

Introduction to Bitmasking in SQL Server 2005

The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005.   Read more...
By Lee Everest 2006/12/13 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,578 reads

Get all user def table info

Get space for all user defined table information like size and row counts.  Read more...
By Mohit Nayyar 2013/12/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,319 reads

Date and Time in SQL Server 2008

SQL Server 2008 is well on its way to being complete and released with the release of the second CTP recently. There aren't a tremendous number of changes, but one of the more interesting ones is the changes to date and time handling in this new platform. The time and date datatypes have been separated and longtime SQL Server author Vincent Rainardi brings us a short look at how there can be used.  Read more...
By Vincent Rainardi 2007/10/24 | Source: SQLServerCentral.com | Category: news
Rating: |  Discuss |   Briefcase | 12,112 reads

Find Table Usage

By kgayda 2007/10/23 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,247 reads

Function to Split Multivalued Parameter

This Function is written to split Multivalued Parameter passed by Reporting Services 2005.  Read more...
By Hari Sharma 2012/07/16 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,656 reads

Find Column Usage

By kgayda 2007/10/10 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,067 reads

Find Table Usage

By kgayda 2007/10/23 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,247 reads

Partitioning - Part 2

Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques.   Read more...
By Andy Warren 2007/10/08 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,763 reads

Reverse Engineering Alias Data Types in SQL Server 2000 - Part II

Continuing with his series on Alias Data Types, Yakov Shlafman shows us how to work wtih ADTs when constriaints are involved.   Read more...
By Yakov Shlafman 2007/09/03 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,658 reads

Table row count using 3 different ways

Three different ways that you can get the count of the rows in a table.  Read more...
By Mohit Nayyar 2011/06/16 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,422 reads
<< Newer    Items 21 to 40 of 574    Older >>
 
Tags
maintenance and management (162)    
sqlinsider scripts (106)    
programming (45)    
sql server 7 (44)    
backup / restore (28)    
administration (26)    
data warehousing (24)    
indexing (24)    
stored procedures (20)    
strategies (14)    
performance tuning (13)    
advanced querying (11)    
configuring (10)    
lock and connection management (10)    
visual basic 6 (9)    
xml (9)    
sql server 2005 (8)    
database design (7)    
replication (7)    
security (7)    
mail (6)    
monitoring (6)    
basics (5)    
ado (4)    
development (4)    
sql-dmo (4)    
.net (3)    
best and worst practices (3)    
installation (3)    
nums (3)    
openxml (3)    
sql puzzles (3)    
table of numbers (3)    
tally (3)    
updategrams (3)    
user defined function (udf) (3)    
counter (2)    
dts (2)    
naming standards (2)    
news (2)    
table (2)    
triggers (2)    
worst practices (2)    
xsl (2)    
analysis services (ssas) (1)    
asp (1)    
best practices (1)    
distributed queries (1)    
english query (1)    
full-text search (2005) (1)    
games (1)    
prime (1)    
prime number (1)    
puzzle (1)    
schemas/dtds (1)    
semaphore (1)    
sieve (1)    
sql server 2008 (1)    
utility (1)