T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Set timeout for specific queries?

  Hi, is it possible to set a specific timeout for a query? Example: SET TIMEOUT_FOR_THE_FOLLOWING_QU…

  dev-fridge

  3 replies

  16 years, 5 months ago

  By: Grant Fritchey

• What is the equivalent of Lead / Lag (Oracle Analytics) in SQL Server 2008

  Hi, Could any one point me to which functionality of SQL Server 2008, does Lead / Lag of Oracle Ana…

  gvsriramakrishna

  2 replies

  16 years, 5 months ago

  By: SQLWinther

• Spatial Problem -- Polygons

  I've scratched my head over this for hours. Can someone tell me why @G1 works and @G3 doesn't wor…

  The Dixie Flatline

  9 replies

  16 years, 5 months ago

  By: The Dixie Flatline

• Why can you use"-+-+-+" in tsql?

  When I was trying what kind of construction TSQL in SQL 2008 would allowed I came at this stupid co…

  Alexander Kovacs

  13 replies

  16 years, 6 months ago

  By: ChiragNS

• Joing spatial data from two tables

  I got one table of polygons, that I want to lay over top of the results from another layer of polyg…

  blast2hell

  6 replies

  16 years, 6 months ago

  By: blast2hell

• Round up to nearest half dollar

  Hello all - I hope someone out there can help me. I need to create a function which rounds a numbe…

  day-ce

  7 replies

  16 years, 6 months ago

  By: Gail Shaw

• How to clear IOSTATS in sys.dm_io_virtual_file_stats?

  How to clear IOSTATS in sys.dm_io_virtual_file_stats? In the old day, dbcc sqlperf(IOSTATS,CLEAR) w…

  mycorrado

  2 replies

  16 years, 7 months ago

  By: mycorrado

• Variable #of arguments to UDF/stored procedure

  Hi All I have a problem I'd like to solve in SQL, but not sure if it's possible..so some ideas woul…

  thusi-886269

  11 replies

  16 years, 8 months ago

  By: Jeff Moden

• Creating a pseudo column with hard coded values in the result set of SELECT statement

  I have a table with columns Customer_ID,Name,Country in Customers Table. I want to SELECT columns C…

  TA-472286

  2 replies

  16 years, 8 months ago

  By: Ken McKelvey

• How to use column name inlike clause in SQL server

  Currentely I am facing a problem while converting Access qurey into sql server I want to convert fo…

  maroti.rodge

  9 replies

  16 years, 9 months ago

  By: gururajan

• Identifying gaps between intervals

  Hi All I have a fairly complex problem I believe is going to require some good temporal SQL. I have…

  thusi-886269

  10 replies

  16 years, 9 months ago

  By: thusi-886269

• OSQL in 2008

  Hi all, Just wanted to see if anyone knows whether 2008 support OSQL calls? Is there a Add-In I can…

  mboddoo

  2 replies

  16 years, 9 months ago

  By: mboddoo

• intellisense

  Just been trying out the intellisense, and noticed something which in my opinion is rather poor. it…

  Paul.Allen-791132

  2 replies

  16 years, 9 months ago

  By: Grant Fritchey

• Deadlock troubleshooting

  Hi, I am trying to find out why we have deadlocks on the SQL Server 2008 test box. I have the dead…

  Roust_m

  5 replies

  16 years, 10 months ago

  By: Roust_m

• Performance benifits of MERGE ?

  Hi there, Is there a performance benifit to using a MERGE statement to update/insert/delete data vs…

  Christopher Klein

  4 replies

  16 years, 10 months ago

  By: Erik Bitemo