SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Cause of concern?

  Is there a cause for concern if one of the tables in SQL2008 has a VARCHAR field. And in that field…

  MSSQL_NOOB

  4 replies

  12 years, 8 months ago

  By: MSSQL_NOOB

• Display results even if Joined table doesn't have any matches

  SELECT Records.Listcode, Records.JulianDate, Records.Records, COUNT(sales_view.JulianDate) AS Sales…

  ncurran217

  1 replies

  12 years, 8 months ago

  By: ncurran217

• Delete datetime record

  How to code to delete record in ORDERDATE for bbb? NAME------ORDERDATE ----------------------------…

  adonetok

  5 replies

  12 years, 8 months ago

  By: logitestus

• MCTS to MCSA - 2008 or 2012?

  Hi all, I'm after some advice if I may? After passing my SQL Server MCTS (imp & maint) late la…

  WWDMark

  13 replies

  12 years, 8 months ago

  By: Beatrix Kiddo

• Unable to view the triggers

  Hi friends, I have created trigger for login 'XXXX' in master database which does not exceeds 3 ses…

  sundar329

  4 replies

  12 years, 8 months ago

  By: sundar329

• DBCC FREEPROCCACHE to shink TEMPDB

  Good Day All As you know sometimes when a query is run that fills up or grows tempdb to a large siz…

  Snakeyes

  5 replies

  12 years, 8 months ago

  By: Snakeyes

• add an alias field

  Hi, I have a table with products name from a group (1.3.7.2.1). All products which has this group a…

  zanete_sorin

  2 replies

  12 years, 8 months ago

  By: zanete_sorin

• Database Properties Data and Log initial and Auto growth help!!!!

  F: drive is total 100GB and now 75GB space left (only drive besides C: and it’s on VM Ware don’t …

  Tac11

  5 replies

  12 years, 8 months ago

  By: HanShi

• Getting the CPU Utilization Of SQL SERVER 2008

  Hello Everyone, I'm trying to get the Memory Usage of the SQL SERVER (Total Memory Usage) and avail…

  pnagaraju

  5 replies

  12 years, 8 months ago

  By: pnagaraju

• Need Urgent help to convert nVarchar to Numeric in SQL

  Dear friends, I have field "Monthly_Cost" in DB that is nVRACHAR - with value '2094', how to conve…

  dhananjay.nagarkar

  7 replies

  12 years, 8 months ago

  By: Erland Sommarskog

• Import\export wizard

  I am currently using the wizard to import some data from excel to SQL. typical values im importing.…

  SQLAssAS

  22 replies

  12 years, 8 months ago

  By: Koen Verbeeck

• Error moving from test to production server

  Hello, I am receiving this error type always, when i move my package from test server to production…

  Shaun2012

  4 replies

  12 years, 8 months ago

  By: Shaun2012

• increment id based on column value

  Hi ! I hope that you can show me how to do it avoiding using loop. I need to group records imported…

  Mark Gorelik

  10 replies

  12 years, 8 months ago

  By: Mark Gorelik

• Better insert performance on a table only with a clustered index or a table without any index on SqlServer 2008?

  Note, I am not talking about a clustered index against a non-cluster index, I mean a clustered inde…

  qwert1234567

  3 replies

  12 years, 8 months ago

  By: sturner

• REBUILD 1625 indexes weekly !!??

  I just joined this company and look at some SQL jobs they run on production server. One of them loo…

  RVO

  4 replies

  12 years, 8 months ago

  By: RVO