Development

• Topics

  Started by

  Posts

  Last post

• Large Comment Blocks Causing Issues

  I have had some real performance issues as well as some 'phantom' problems. After a long and arduo…

  David Paskiet

  9 replies

  14 years ago

  By: David Paskiet

• read uncomitted doesn't work

  I have a stored procedure which does a select to return data for a report. The sp has set transacti…

  MattTheDBA

  9 replies

  14 years ago

  By: MattTheDBA

• Trying to get max value with column name for each row using pivot?

  I need to get max values for each row and its column name. For ex: My table: Zipcode West East Nort…

  sql4us

  9 replies

  14 years ago

  By: Martin Schoombee

• Where the Data is Stored if Select query executed before placing to Grid?

  Hi Guys, I know it, the question is Funny, but i just wondering the SQL system workout, how the dat…

  patelmohamad

  6 replies

  14 years ago

  By: Gail Shaw

• Table variable as Output Parameter

  Can I declare table variable as output parameter in stored procedure?

  aziz.kapadia

  18 replies

  14 years ago

  By: marcjell

• sqlservr.exe 100% utilization --- Urgent

  hi Friends, Recently i am facing the issue in production server which 100% cpu by sqlservr.exe . …

  Rajo

  18 replies

  14 years ago

  By: Ninja's_RGR'us

• Profiler: Stored procedure executed successfully but SP:completed and RPC:completed now showing. Why?

  HI, Edition:SQL 2005 64 Bit In profiler, i have selected SP:starting, SP:Completed, RPC:starting an…

  iBar

  2 replies

  14 years ago

  By: iBar

• Dynamic Stored Proc to generate Create Table Script ,taking table_name as parameter

  Hi I am looking to make Dynamic Stored Proc to generate Create Table Script ,taking table_name as p…

  Alkesh Khedle

  8 replies

  14 years ago

  By: yoosufshanij

• IF Exists(Query)

  If i use the below query to check the data available or not in the table the result print perfect. …

  patelmohamad

  11 replies

  14 years ago

  By: patelmohamad

• Search Question

  Is there a way to search a string across values of all the columns of all the tables

  sqlnaive

  9 replies

  14 years ago

  By: John Mitchell-245523

• difference between composite index and single index

  Hi i am curious to know what is the difference between CREATE INDEX PIndex ON Persons (LastName) , …

  ajaysanhotra

  6 replies

  14 years ago

  By: Bruce W Cassidy

• Problem with getting the count of records when using group by and having

  Hello All, I have the below query returning the result set. I just want to get the total records re…

  vijay-367524

  1 replies

  14 years ago

  By: Ninja's_RGR'us

• Using Identity Field as my main relation in joins

  Hi, In all my tables my first field is an Identity field which is set as my primary key. Is it a …

  sammuts

  10 replies

  14 years ago

  By: tfifield

• Question on INSTEAD OF TRIGGER with IDENTITY Column

  I am creating a Trigger to tracking all DML activities on a table, and same the old data into histo…

  yeek li

  5 replies

  14 years ago

  By: SwePeso

• Indexes on Test_server(dababase) is out of sync of Prod server (database)

  The indexes on the Test database on Test server are out of sync with PROD database on Prod_server, …

  bala2

  4 replies

  14 years, 1 month ago

  By: Grant Fritchey