SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• datetime conversion oddity

  Hi all, Could somone explain why the following works for days other than 13/04? DECLARE @stop_time …

  Ulysses_Infinity

  5 replies

  8 years ago

  By: Luis Cazares

• Audit Database Properties Changes

  There is something weird going on with one of my servers. Seems like someone is changing the auto g…

  keanyukas

  2 replies

  8 years ago

  By: keanyukas

• Changing raw IP to FQDN in connection strings - any potential issues?

  Our setup I have a small hosting setup consisting of an SQL Server (2008), a couple of webservers a…

  torben 67322

  3 replies

  8 years ago

  By: dsinghkr

• Installing SQL Server 2008R2 Ent Edit On VMWare Q

  We are in the process of implementing a new SANS that will host all of our servers/systems.  I…

  YSLGuru

  2 replies

  8 years ago

  By: YSLGuru

• Index rebuilt/Reorganize script didn't remove fragmentation

  I have a script which I ran last night on one of my DB which is on the dev server but when I check …

  NewBornDBA2017

  6 replies

  8 years ago

  By: Perry Whittle

• Shrinking log file

  Today we have  received   issue that one of the log file in  a database is grow…

  ramyours2003

  4 replies

  8 years ago

  By: ScottPletcher

• Deleting old records isn't freeing up space?

  We have 1 table in our database which is about 220 GB in size and since we are running out of space…

  NewBornDBA2017

  3 replies

  8 years ago

  By: Steve Jones - SSC Editor

• Updating null fields wehn changing field to not null.

  Hi, we have a flat table in SQL server that has no PK field and no constraints. The table is manual…

  david_h_edmonds

  7 replies

  8 years ago

  By: david_h_edmonds

• Purge database

  Hello I have just started a new job and my first task is to purge the database.This is a transacti…

  Lidou123

  15 replies

  8 years ago

  By: crmitchell

• database diagram - "add related table" greyed out

  Hi there With SQL 2008 database diagram - when I right click on my table to add related tables, thi…

  Chris Hewitt-261101

  4 replies

  8 years ago

  By: danbarroso

• SQL Server Agent Job question

  I'm new to SQL Server Agent.  What I want to do is execute a small script to run a stored proc…

  celia 34404

  12 replies

  8 years ago

  By: sgmunson

• Database corrupt - Msg 8966, Level 16, State 2, Line 1

  Server : SQL Server 2008R2Microsoft Windows server 2008 R2 Msg 8921, Level 16, State 1, Line 1Check…

  Sanz

  4 replies

  8 years ago

  By: Gail Shaw

• Moving data from rows into single delimited field

  Does someone have a solution for this.  If there is more than one MyId1 it needs to be in a si…

  texpic

  6 replies

  8 years ago

  By: saravanatn

• ad hoc queries

  Hi What is ad hoc queries? and what is the difference between ad hoc queries and dynamic queries?

  mah_j

  10 replies

  8 years ago

  By: essbasecube 59146

• TDE with trusted certs

  Hello. We are switching from self signed certs to trusted 3rd party certs and we are able to do so …

  TheMaskedDBA

  8 replies

  8 years ago

  By: TheMaskedDBA