News

Date and Time in SQL Server 2008

  • Article

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.

4.13 (32)

2007-10-24

12,220 reads

Passing a Table to a Stored Procedure

  • Article

SQL Server 2008, code named Katmai, has some very interesting additions to the SQL Server platform to make your development tasks easier. One of these is passing a table variable as a parameter to a stored procedure and regular columnist Jacob Sebastian shows us how.

4.23 (22)

2009-02-13 (first published: )

31,426 reads

Blogs

Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2

By

How to read execution plan to improve poorly... [[ This is a content summary only....

VSCode Tips–Remove the Highlighted Line

By

VSCode was making me crazy as I was writing a script. I like a...

Use T-SQL, not the GUI

By

There’s a very good reason to do most of your DBA work using T-SQL,...

Read the latest Blogs

Forums

business intelligence development studio(Bids)

By Nivs719

Hello, I have a SQL 2017 and I want to use business intelligence development...

MEMORY CONSUMPTION SQL 2012

By sharon-472085

hi all, as you can see in attachment sql take 122  giga memory. and...

Issue with max() and aggregate, missunderstanding

By insomnius

Hi all, this is my first post here and I've been looking and trying...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers