SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• CASE Statement with Date

  Need help on writing case statement We were assigned to modify the existing query. So, we need to w…

  Tamrak

  6 replies

  10 years, 6 months ago

  By: Jeff Moden

• Is it possible for the client to connect to the Mirror server after connection is broken between Principal DB and Mirror DB

  Hi, Earlier mirror was configured but due to some reason the connection was broken between principa…

  mokarram_nazri

  6 replies

  10 years, 6 months ago

  By: mokarram_nazri

• Restore a point between two full backups

  Hi, I make two full backups on Oct 1 and Oct 10. I want to restore the server to a state in Oct 5. …

  keithy_sunny

  4 replies

  10 years, 6 months ago

  By: Gail Shaw

• What is the meaning of hbcolid field?

  Hi, I just connect to SQL Server and invoke the following command: Select * from sys.sysrscols The …

  keithy_sunny

  1 replies

  10 years, 6 months ago

  By: Gail Shaw

• need to help a query in sql server

  I have a question about SQL Server. CREATE TABLE emp (id INT, NAME VARCHAR(20), sdate DATE, edate D…

  balukumar

  3 replies

  10 years, 6 months ago

  By: sourav.2007.ghosh

• Report Builder (Stored procedure)

  Hi I am trying to call a stored procedure into report builder. The stored procedure has 2 parameter…

  SQLPain

  3 replies

  10 years, 6 months ago

  By: SQLPain

• Stripping part of a filename

  I have a filename as follows: 123_20151016_3152_AIRHtest1.txt What I would like to extract from thi…

  Meatloaf

  3 replies

  10 years, 6 months ago

  By: Ed Wagner

• Is CDC really Replication (or if thats what ETL is, why did we go through all these changes?)

  As i understand it, CDC reads the log for a particular table and remembers the inserts, updates and…

  drew.georgopulos

  9 replies

  10 years, 6 months ago

  By: karlgoldman

• Whether the full backup includes log backup?

  Hi, In SQL Server, whether the full backup of a database includes the backup of the log? Thanks

  keithy_sunny

  2 replies

  10 years, 6 months ago

  By: ScottPletcher

• Need help with a query that returns only rows that meet specific condition

  Hi there, I know this is probably a basic SQL question, Here's what my table looks like; UniqID | C…

  rourrourlogan

  11 replies

  10 years, 6 months ago

  By: Luis Cazares

• Why query optimizer does not recognize that index is sorted, for partitioned table?

  I have a large partitioned table, it is partitioned by clustered index. All remaining non-clustered…

  SQL Guy 1

  1 replies

  10 years, 6 months ago

  By: SpeedySQL

• Speed up following query (Second opinion needed)

  Hello all, Following scenario Database Global Storage There is a daily import of servers and their…

  Resender

  24 replies

  10 years, 6 months ago

  By: ChrisM@Work

• How to get the collation name from a collation ID?

  Hi, I am using SQL Server 2008. In ServerProperty function, there are two properties called “Collat…

  keithy_sunny

  1 replies

  10 years, 6 months ago

  By: SpeedySQL

• ANyone ever seen this error (SQL Server 2008 trying to edit a job step)

  TITLE: Microsoft SQL Server Management Studio ------------------------------ Creating an instance o…

  Resender

  3 replies

  10 years, 6 months ago

  By: Resender

• General question

  Is there a tool any one knows that would go and change passwords. So basically if i provide a serv…

  curious_sqldba

  3 replies

  10 years, 6 months ago

  By: Anonymous