SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• A Database with 70 Table

  hi everybody I Have Database With 70 Tables and this my first time that i have alot table in my DB.…

  vahid.arr

  12 replies

  11 years, 2 months ago

  By: v.sierra

• Work Pattern Calendar Tables

  Hi, I need to prove that there is a speed issue with one of our stored procs/functions but to do th…

  itwhiz

  5 replies

  11 years, 2 months ago

  By: itwhiz

• Temporary Tables Causing Stored Procedure Recompiles

  Hi Everyone, I have a case where I have two conflicting performance objectives. 1. Always creatin…

  Nick Doyle

  8 replies

  11 years, 2 months ago

  By: Evil Kraig F

• Parsing data from single column into multiple columns

  Hi, I'm working with a field of data that has city, state and zip all on the same column within SQL…

  hermanator

  5 replies

  11 years, 2 months ago

  By: Luis Cazares

• Possible to unCompress or deCompress compressed table and index in SQL 2008 R2?

  New EMC architecture offering De-Dup requires avoidance of SQL Server data compression. We've com…

  Express12

  4 replies

  11 years, 2 months ago

  By: Discontinued Account 99

• tempdb log 75GB

  tempdb log has grown crazy large. It is 75GB and is running in simple recovery mode. Does anyone k…

  lawson2305

  11 replies

  11 years, 2 months ago

  By: Jack Corbett

• user permissions after restore

  As I understand it if you restore a backup from Server X of database A to Server Y to database A th…

  PearlJammer1

  4 replies

  11 years, 2 months ago

  By: PearlJammer1

• T-SQL

  Hi, Pls suggest me which is best one in below two queries. Create Table ABC(name varchar(1)) Inse…

  balu.arunkumar

  3 replies

  11 years, 2 months ago

  By: Grant Fritchey

• Easier way to display 12 month range.

  Hi clever people The following code just look/seem silly to me, thus the posting. Does anyone have …

  frdrckmitchell7

  3 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• String manipulation functions suddenly consume a lot more CPU

  Hi All, The CPU usage of one of our production SQL servers has increased significantly, from normal…

  rupengzhao

  4 replies

  11 years, 2 months ago

  By: rupengzhao

• Wondering about Cumulative Update in SQL

  HI All , I am going to apply Cumulative update 17 in SQL Server 2008 SP3 because I have a problem w…

  WhiteLotus

  2 replies

  11 years, 2 months ago

  By: WhiteLotus

• Inserting a dash between some values AND Adding a leading zero if only 5 characters

  Hi Guys I need a bit of help. I have a column with integer records of 5 and 6 characters. example …

  C-kweldude

  8 replies

  11 years, 2 months ago

  By: Luis Cazares

• Tools for graphical format

  Hi Experts, Other than SSRS, is there a cheap product or free tool that can present SQL Queries in…

  Nagaram

  3 replies

  11 years, 2 months ago

  By: Jeff Moden

• Transaction Log Growth

  Hi All - I have recently set up an alert which I want to test but not sure how. I have an alert on…

  arrjay

  7 replies

  11 years, 2 months ago

  By: arrjay

• SSMS 2008 - Shows Service Status as Stopped Though Service is started

  Hi, I have a SQL Server 2008 - Active/Passive Cluster. The issue I am facing here is that, when I d…

  Deeps001

  6 replies

  11 years, 2 months ago

  By: NJ-DBA