SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• sql DB table handling thousands of inserts a sec

  I have a sql server 2008 database setup that accepts insert transactions from a visual studio appli…

  j_depp_99

  29 replies

  14 years, 6 months ago

  By: Elliott Whitlow

• Synchronizing with Google Calendar?

  Hi there, Anyone who has experience with synchronizing a SQL table with Google Calendar? I need to …

  Raymond van Laake

  2 replies

  14 years, 6 months ago

  By: Lowell

• t-SQL Optimization

  Hi Guys, Could you please take a look at the query below and let me know how can I optimize it... I…

  Laura_SqlNovice

  2 replies

  14 years, 6 months ago

  By: SQLRNNR

• Sql Server 2008 Enterprise Evaluation Edition Expired!!

  hi i had used Sql Server 2008 Enterprise Evaluation Edition on my machine. now i am getting the err…

  RockingAdmin

  36 replies

  14 years, 6 months ago

  By: p.van.der.zande

• Cache - Hit & Miss

  Hi, I was wondering if someone could explain something to me. In the attached script I am running 2…

  InvisibleCat

  2 replies

  14 years, 6 months ago

  By: InvisibleCat

• Connection pooling and web applications

  I'm curious about how connection pooling actually works because I'm not sure if my application is u…

  andegre

  3 replies

  14 years, 6 months ago

  By: Sean Lange

• numeric precision and scale question

  I am embarrassed to ask this question; I've read so many things on precision and scale but still do…

  TB-462197

  3 replies

  14 years, 6 months ago

  By: TB-462197

• Index and table maintenance question

  Hi all When looking at Indexes that are being maintained but not updated, I found one that applies …

  Kwisatz78

  4 replies

  14 years, 6 months ago

  By: Kwisatz78

• want to remove subquery from join?

  Hi this is my query which is giving me result. But i need to format my query i want to remove sub q…

  ashuthinks

  1 replies

  14 years, 6 months ago

  By: Gail Shaw

• Browse for Network SQL Servers Only Shows Machine Name Not Instance Name

  Network SQL Server instance names are not coming back in both SSMS and a .Net SQL browser, yet if t…

  tchnupa

  5 replies

  14 years, 6 months ago

  By: GSquared

• Select top row and second top row from DIM table

  I have a dim table (publish.dim_strategy). The strategies here get expired. I want to select the to…

  duggal.priyanka06

  7 replies

  14 years, 6 months ago

  By: Thomas Abraham

• What SQL permission to grant

  I created a new user in the server. This user will be responsible for backup and restore of all use…

  smile_netz

  3 replies

  14 years, 6 months ago

  By: Perry Whittle

• What threshold value is optimal for index rebuild ?

  I am creating a script to rebuild/reorganize all indexes in our database, so I have 3 parameters fo…

  SQL Guy 1

  10 replies

  14 years, 6 months ago

  By: Gail Shaw

• Export result to csv with column header

  hi all my requirement is to export a query result to CSV with the columns name how do i achieve thi…

  ghanshyam.kundu

  3 replies

  14 years, 6 months ago

  By: ghanshyam.kundu

• Sql server Functions

  Hello Friends, We all know that; we can't use DDL in between a sql function but what is the archite…

  shivendrakumaryadav60

  7 replies

  14 years, 6 months ago

  By: shivendrakumaryadav60