SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '('.

  Hi guys, I'm running below script to get the list of fragmented indexes but I'm getting this error:…

  whitesql

  4 replies

  11 years, 5 months ago

  By: whitesql

• returning values with COUNT less than n

  Is there a way to add a count of the occurances of my concatenated field "ConCatCNLN" that have a c…

  SQLalchemy

  4 replies

  11 years, 5 months ago

  By: MMartin1

• Script to display record side by side

  Hello SQL Server family, I am having trouble recalling how to create script to display results side…

  RazorbackDBA

  10 replies

  11 years, 5 months ago

  By: MMartin1

• Changing server name - all procs, views, functions, etc

  Hi, I have to make a copy of our production DB and move it to a new server. New server has differe…

  krypto69

  6 replies

  11 years, 5 months ago

  By: Gail Shaw

• Transaction Log auto-growth

  I have been reading about optimizing the transaction log and how important it is to get the right v…

  timwell

  1 replies

  11 years, 5 months ago

  By: Gail Shaw

• database data file disappeared

  Experts: We are running SQL 2008R2. Our production data spans across three datafiles D:\, E:\ and F…

  SQLJay

  1 replies

  11 years, 5 months ago

  By: Gail Shaw

• Handling Nulls in a PIVOT

  I have the following schema, data, and query to produce a PIVOT output, but I'm struggling with how…

  SQLalchemy

  5 replies

  11 years, 5 months ago

  By: SQLalchemy

• Check who add datafile to a database

  Hello, Is there anyway to get who add a datafile to my database (Profiler, default traces, etc.) Th…

  Jorge Mendes

  2 replies

  11 years, 5 months ago

  By: SQLRNNR

• Need some help with the query:

  Can someone try to help me with this? I got this from my co-worker and he is having some issues whe…

  LearningDBA

  1 replies

  11 years, 5 months ago

  By: Jack Corbett

• Help needed in sqlservers connection

  Hi, I have two database in different servers and i need to access one db object in another db. for …

  KGJ-Dev

  3 replies

  11 years, 5 months ago

  By: KGJ-Dev

• Want to Convert PRIMARY KEY from NONCLUSTERED TO CLUSTERED pls Advice !!

  Friends, Table Structure: CREATE TABLE MappingTable ( [Column1] [int] IDENTITY(1,1) NOT FO…

  prabhu.st

  4 replies

  11 years, 5 months ago

  By: prabhu.st

• set date value based on other row values

  Sorry for the Header, I can't find the right way to describe what I want, possibly the reason why I…

  carsten 97262

  2 replies

  11 years, 5 months ago

  By: carsten 97262

• Powershell script to get the Disks that are offline

  Hi I have a scenario where in i need to get disks infomation of 100+ remote servers using powershel…

  Mac1986

  1 replies

  11 years, 5 months ago

  By: Tom257

• "sys.dm_db_index_usage_stats" has missing information

  As far as i know sys.dm_db_index_usage_stats should have one record per table and index but in one…

  Bhuvnesh

  2 replies

  11 years, 5 months ago

  By: Bhuvnesh

• Transpose rows into one column

  Hi guys, I have a table with a lot of data like in the example: unic | nrc | nr_tel | id_stud -----…

  MariusC

  11 replies

  11 years, 5 months ago

  By: ChrisM@Work