SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Database design question

  Hi there, I have Company information such as CompanyNo, Company Name, Address,Num of Employees. I…

  rash3554

  4 replies

  12 years ago

  By: CKX

• What processes can update records without firing a trigger

  I am working on a problem where we have a table that periodically gets updated with incorrect data.…

  kmclaren

  3 replies

  12 years ago

  By: Jeff Moden

• Change varchar data type of columns to real/ decimals

  Hi, I've imported text files into SQL server and by default the fields are varchar(50) data type. I…

  mic.con87

  2 replies

  12 years ago

  By: djj

• Plan Cache - Query plan size

  Hi all It is my understanding that the area of memory dedicated for SQL Plans is part of the buffer…

  SQLSACT

  5 replies

  12 years ago

  By: Grant Fritchey

• Clustered index design

  I have a table with 170 million rows, ~ 40GB of data space (~30GB of index space). Let's assume: CR…

  Kevin-221552

  3 replies

  12 years ago

  By: Kevin-221552

• SSIS importing of Excel information.

  Hello All, I think this should go under: SQL Server 2008 Integration Services But there is no such …

  ben.brugman

  2 replies

  12 years ago

  By: ben.brugman

• code folding in ssms?

  Hello - What are some techniques you use for code folding in SSMS? For example, in Visual Studio y…

  sqlguy-736318

  8 replies

  12 years ago

  By: ssms-man

• DB in suspect mode after Log shipping restore

  Hello, Secondary DB goes into suspect mode after Log shipping restore. while checking error logs fo…

  SQLb2t

  4 replies

  12 years ago

  By: CKX

• Insert into multiple tables

  Hi All, I need to insert approximately 500k rows into sql, but on each insert i need to get the ins…

  CookieMonster

  2 replies

  12 years ago

  By: CookieMonster

• UPDATE , DELETE result is blocking

  Hi Experts, I have a situation where deleting old records is blocking updating latest records on hi…

  Jampandu

  11 replies

  12 years ago

  By: sharky

• Reg bedrents calculation in HIS stored procedure

  Hi All, I have created a stored procedure for calculating the bed resnts in hospital information sy…

  p.avinash689

  3 replies

  12 years ago

  By: p.avinash689

• Convert file from ANSI to UNICODE

  Currently, we generate file in ANSI. Is there a setting we need to change to generate files in UNIC…

  SQL_Surfer

  20 replies

  12 years ago

  By: SQL_Surfer

• need query unpivot in sql servr

  Hi friends i have small doubt in sql server please tell me how to solve this issuse in sql server. …

  asranantha

  1 replies

  12 years ago

  By: Jeff Moden

• sysjobhistory date and time

  Hi all - I've been tasked with writing 2 reports one showing what jobs ran between 9am and 9pm, a…

  Uripedes Pants

  4 replies

  12 years ago

  By: Lynn Pettis

• Performance Issues - Want to Stop All Incoming Connections for Specified Hosts

  Without modifying firewall settings, is there a way to refuse connections from withing sql server f…

  joshdbguy

  3 replies

  12 years ago

  By: joshdbguy