SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Shrinking data file / Move database

  Recently we had a 2TB database with one data file and one log file. Last week, all objects within …

  SQLSeTTeR

  7 replies

  13 years, 1 months ago

  By: SQLSeTTeR

• Curious: performance difference when using function in a where clause.

  Hello all, This is just something I noticed and am wondering about (I think this is an unexpected e…

  ben.brugman

  9 replies

  13 years, 1 months ago

  By: ben.brugman

• addinga Func to an SP?

  Hi First time doing this and not sure how(Even if its the proper way) I created the function Getfor…

  jbalbo

  4 replies

  13 years, 1 months ago

  By: Lynn Pettis

• ER diagram and related query!

  Hi I am getting 1000 rows returned from this Query: (see attached ER diagram) select * from Custome…

  tercou1

  4 replies

  13 years, 1 months ago

  By: tercou1

• sql query count()

  Hello , I have a scenario which is similar to the ones below : There are two tables Transaction a…

  SqlServerNinja

  3 replies

  13 years, 1 months ago

  By: Sean Lange

• There is insufficient memory available in the buffer pool.

  Please help me. I m try to import data from csv to table using bulk insert but it gives me insuffic…

  writearjun53

  9 replies

  13 years, 1 months ago

  By: TheSQLGuru

• skipping reboot check while installing sql server and remove command line appearing during install

  While i am installing sql server 2008r2 by using configuration file sometimes i am getting error in…

  IT researcher

  1 replies

  13 years, 1 months ago

  By: IT researcher

• Monitoring Tools

  What are the best tools available for monitoring MSSQL and Oracle databases. Our end goal is to ha…

  JeepHound

  3 replies

  13 years, 1 months ago

  By: Grant Fritchey

• data update strategy

  Hello - I'm trying to think of some good strategies for making data updates in Prod. Transactions …

  sqlguy-736318

  2 replies

  13 years, 1 months ago

  By: Grant Fritchey

• Query running slow

  Hi, Sql queries were running slow and these are triggering from They are supposed to run for 5-10 …

  seven.srikanth

  3 replies

  13 years, 1 months ago

  By: Grant Fritchey

• Display Every three rows has diffrent color repeatedly using tablex report in ssrs

  Hi All, I have one requirement like report display 25000,client want to display row1=green, row2=bl…

  viveksvkola

  1 replies

  13 years, 1 months ago

  By: deepkt

• validating values

  Hi, I have a screen from which some columns values like VoucherNo, Denomination, Quantity etc. I ha…

  kapil_kk

  4 replies

  13 years, 1 months ago

  By: Koen Verbeeck

• SQL login Timeout expired .

  Hi We have Windows 2008 box with 9 sqlserver instances all instances are 2008 R2. One of the user c…

  Sunny03

  10 replies

  13 years, 1 months ago

  By: Steve JP

• Search table field with LIKE clause

  How to improve performance with the LIKE clause. I have the following view definition SELECT Distin…

  kk1173

  24 replies

  13 years, 1 months ago

  By: kk1173

• no rows returned from sys.dm_exec_requests

  Im checking for sessions with a lot of activity against them. im using the following query: selec…

  winston Smith

  4 replies

  13 years, 1 months ago

  By: winston Smith