SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How to change date format in sql server 2008 r2 for all sessions?

  How to change date format in sql server 2008 r2 for all sessions? I tried, EXEC sp_configure 'defau…

  Aadhar Joshi

  2 replies

  13 years, 5 months ago

  By: Aadhar Joshi

• Why does Delete/Update grab an exclusive lock?

  In books online it says DELETE & UPDATE always grab an ex table Lock. Im trying to figure the …

  winston Smith

  2 replies

  13 years, 5 months ago

  By: Gail Shaw

• SQL Server Statistics

  Hi to all, is it possible to force SQL Server 2008 not to use Range_ROWS in its statistic ? I have …

  scziege

  1 replies

  13 years, 5 months ago

  By: Koen Verbeeck

• bringing consecutive days on the same row as start date and end date

  I want group data so that the consecutive days for same Location and Contac tName come on one row a…

  dk98681

  12 replies

  13 years, 5 months ago

  By: Lokesh Vij

• Would you store foreign key from grandparent tables? Why or why not?

  I'm curious about potential ramifications of storing a foreign key that is derivable. For example, …

  Banana-823045

  8 replies

  13 years, 5 months ago

  By: CapnHector

• MSDB Errors

  Hello, Whenever I run my full backup maintainance plan job the backups get completed successfully b…

  Pyman

  2 replies

  13 years, 5 months ago

  By: Pyman

• Is there a way to Identify if a database is no longer in use

  Hi Guys, Is there a way to identify old databases that are not in use? 😀 Well aside from checking …

  jnuqui

  8 replies

  13 years, 5 months ago

  By: Anonymous

• Lined Servers over a VPN

  Our client would like to connect to our SQL server through their SQL server using the linked server…

  Guras

  1 replies

  13 years, 5 months ago

  By: MyDoggieJessie

• How to uninstall a SQL server named Instance on a two node SQL cluster

  Hi, I currently have a two node SQL Cluster with two named instances: SQLinstance1 and SQLInstance2…

  APA0876

  3 replies

  13 years, 5 months ago

  By: dan-572483

• trigger not updating desired record

  I have a trigger that is supposed to fire when I enter a transaction from my webpage... this transa…

  DaveBriCam

  6 replies

  13 years, 5 months ago

  By: Eugene Elutin

• How do I lock Queries

  hi How do I lock Queries?

  kiasystemsoft

  7 replies

  13 years, 5 months ago

  By: kiasystemsoft

• I got another letter from IRS

  When I am trying to login from my pc get in error message: Can't generate SSPI Content MY sql serve…

  Krasavita

  5 replies

  13 years, 5 months ago

  By: MyDoggieJessie

• Shrink database after archiving

  We've archived massive chunk of data from two databases on a SQL instanace. Now want to shrink the …

  SqlSavy

  5 replies

  13 years, 5 months ago

  By: ScottPletcher

• Master Data Services Complicated Business Rules

  We are investigating the use of Master Data Services at my company. One of the stumbling blocks I'…

  Angela Henry

  2 replies

  13 years, 5 months ago

  By: Nathan Alden, Sr.

• Detect change of month and year in datestamp

  I have a table with datestamp entries as below SELECT st.startup_Time FROM #KWHtemp st OUTPUT: …

  leesider

  10 replies

  13 years, 5 months ago

  By: Sean Lange