SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Spatial Data not returning correct distance

  I have the two following locations. They're both towns in Australia , State of Victoria Fitzroy,-37…

  .Netter

  2 replies

  11 years ago

  By: .Netter

• Performance problems with bulk insert command

  We have performance problems with bulk insert. Where should I start troubleshooting this problem? …

  SQL Guy 1

  9 replies

  11 years ago

  By: ScottPletcher

• How to check a PAth existing uysing T SQL

  HI, whenever I use the below script, it throws the below error. Any suggestion, what's going on wro…

  SQL_Hunt

  2 replies

  11 years ago

  By: SQL_Hunt

• DB is marked RestorePending, which may indicate disk corruption. To recover from this state, perform a restore.

  hello,i have a SQL 2008 R2 RTM production instance, in which we run dBCC CheckDB every weekend to c…

  DBA-640728

  7 replies

  11 years ago

  By: Grant Fritchey

• Stored Procedure help needed please!

  sasa

  15df2o+1caatrp9bznv8

  6 replies

  11 years ago

  By: jonathan.crawford

• Top expensive queries

  Hi All, How do I find out top expensive queries from SQL Server 2008 – Standard edition ? Thank you…

  WhiteLotus

  13 replies

  11 years ago

  By: Eric M Russell

• Findout the type of replication Pull or Push

  Hi, SELECT P.Publication ,P.Publication_type ,S.Subscriber_ID ,S.Update_Mode FROM …

  ramana3327

  2 replies

  11 years ago

  By: ramana3327

• Monitoring the table growth

  Hi, How can we monitor the all tables in all databases and send notifications to the team. Is there…

  ramana3327

  4 replies

  11 years ago

  By: Steve Jones - SSC Editor

• Genarate script in Sql server

  Hi, If we generate script from GUI in Sql server we are able to get Stored Procedures as they are (…

  kysphaneendra

  7 replies

  11 years ago

  By: Grant Fritchey

• Getting problem while running cube

  Hi, Getting below error while processing the cube.Could you please help The following system erro…

  sushil_dwid

  1 replies

  11 years ago

  By: RTaylor2208

• Updating Geography column by passing in lat and long for that row.

  I have the following in my table As you can see the Geo field is null (which is of type Geography)…

  .Netter

  4 replies

  11 years ago

  By: .Netter

• query required

  ------ create table create table test222(sid bigint, scode nvarchar(50), parentid bigint, sname nva…

  peterausger

  6 replies

  11 years ago

  By: Mark Cowne

• powershell

  Hi, I'm trying to create a table using powershell..following is my syntax $conn = New-Object Syste…

  atulyan.aries

  1 replies

  11 years ago

  By: atulyan.aries

• Can we script out linked server from sql 7.0

  Can someone help me with the syntax of scripting out the linked server. Thanks

  sureshjevani 78421

  1 replies

  11 years ago

  By: Koen Verbeeck

• Shrink System databases

  Hi All, I have some questions : 1.Is it OK to shrink Master, model ? the transaction log for those…

  WhiteLotus

  1 replies

  11 years ago

  By: Jeff Moden