T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Bad performance of a query

  Hi Experts, I was given a stored procedure by a developer to tune it. I used io and time statistics…

  chandan_jha18

  39 replies

  14 years, 7 months ago

  By: chandan_jha18

• @@SPID is deprecated? What should replace this command in the new 2008 R2?

  Hello, I am migrating from SQL 2005 to 2008 R2. Some stored procedures use the system function @@SP…

  DBA Cabuloso

  1 replies

  14 years, 7 months ago

  By: Gail Shaw

• Incorrect Plans on Partitioned Tables

  Hi All, I am new to the company and here we have several tables being partitioned via a creation_da…

  paul.corujo

  2 replies

  14 years, 7 months ago

  By: TheSQLGuru

• Recursive CTE with WHERE clause

  Hello! I have script: ;WITH A(PersID,LastN, FID, MID) AS (SELECT [PersonID] ,[LastName] …

  Shcherbunov Neil

  4 replies

  14 years, 7 months ago

  By: Arjun Sivadasan

• SP with dynamic query running slow; the same dynamic query runs fast separately

  I make this post with a certain amount of guilt; because I feel that I have not searched enough for…

  Arjun Sivadasan

  1 replies

  14 years, 7 months ago

  By: Arjun Sivadasan

• object_id(what) .. returns diffrent value depending on user

  hi, If I login as the schema user and excute SELECT OBJECT_NAME(id) FROM syscolumns WHERE id=objec…

  Edward-445599

  5 replies

  14 years, 7 months ago

  By: Lowell

• Can I create Email Trigger that compares column value in inserted row with value in another table?

  I want to send out an email to Users if they enter incorrect data into database table. The User wil…

  andrew.sugden

  4 replies

  14 years, 7 months ago

  By: schleep

• To create index on varcharcolumn

  hi, can we create an index on an a coloumn on datatype varchar/nvarchar having maximum size? ex …

  raghu-sql

  5 replies

  14 years, 7 months ago

  By: deepak.a

• how to return the result in a stored procedure

  Hi, I wrote a procedure as below... Create PROCEDURE [dbo].[GET_HEIRARCHY_CODE] (@STR VARCHAR(50)) …

  Prasanthi Reddy

  6 replies

  14 years, 7 months ago

  By: Bruce W Cassidy

• Inventory trail help

  Sql Gurus, I have an Inventory trail table where I am going to capture all orders and sales and log…

  misstryguy

  5 replies

  14 years, 7 months ago

  By: misstryguy

• tricky query

  I cannot copy the table structures..but below is the scenario I have a query which runs fine when o…

  Lucky9

  16 replies

  14 years, 7 months ago

  By: Nils Gustav Stråbø

• compare data for each date

  Hi, i have a problem with comparing the data from the several period with the previous data the pr…

  x_japanfans5312

  3 replies

  14 years, 7 months ago

  By: tfifield

• *= non ansi join

  WE have a database that was on SQL 2005 in 2000 compatibility mode and now we're trying to get it t…

  Sailor

  7 replies

  14 years, 7 months ago

  By: Gail Shaw

• replace Nulls with blanks across an entire table

  Does anyone know of a a way to replace "null" with "" across an entire table without having to list…

  LoosinMaMind

  4 replies

  14 years, 7 months ago

  By: Ninja's_RGR'us

• Add a range of scores to a parameter

  I have a list of scores, anything from 10.00 to 151.80 for example. I need to create a range of 10-…

  fergusoj

  7 replies

  14 years, 7 months ago

  By: fergusoj