SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Design question - product history

  Hi, Looking for some advice on the best way to design a table or couple of tables to quickly get an…

  Tom_Hogan

  1 replies

  14 years ago

  By: MVDBA (Mike Vessey)

• SSRS REPORTS SECURITY

  What are the different options to configure access rights to a report in ssrs?.Please let me know a…

  praveen901

  2 replies

  14 years ago

  By: vikingDBA

• Can anyone recommend a good performance tuning series?

  Hi Just wondering if anyone has stumbled across any SQL Server performance tuning video runs or sta…

  derek.colley

  3 replies

  14 years ago

  By: derek.colley

• FILESTREAM messages in error log

  Hi All We have the following messages appearing in the SQL Error Log every 5 mins, like clockwork F…

  SQLSACT

  1 replies

  14 years ago

  By: SQLSACT

• LITESPEED xp_slssqlmaint issue

  Hi al I have been trying to a script using LITESPEED procs however I am getting an error when runni…

  Kwisatz78

  7 replies

  14 years ago

  By: Kwisatz78

• Help with Nested Select statement with join

  Hi I am trying to write a Nested Select statement with a join but keep getting the following error …

  bharatgi

  1 replies

  14 years ago

  By: Gullimeel

• Nested loop outer join question

  I've got a simple SQL... select * from table1 a join table2 bon a.id_rssd = b.id_rssd…

  john (dba)

  16 replies

  14 years ago

  By: john (dba)

• Memory Usage is high

  Hi..... Guys, Is sql server using 25% RAM of total memory available? for eg: if 10 GB of total RAm…

  Saggy

  5 replies

  14 years ago

  By: Divine Flame

• Violation of PRIMARY KEY constraint 'PK_tbl_applicant_skills_test2'. Cannot insert duplicate key in object 'dbo.tbl_applicant_skills_test2'. The duplicate key value is (112).

  Dear All, I'm trying to insert records from multiple tables into a new table but I get the followi…

  tt-615680

  2 replies

  14 years ago

  By: S_Kumar_S

• Setting Named Instance to Single User Mode Doesn't Work

  I'm using the following command from the dos prompt to try to set an instance to single user mode b…

  PhilipC

  5 replies

  14 years ago

  By: Gazareth

• TempDb crashed my server...

  Hi friends, I made a T-SQL statement to insert some records, when i execute this query, it make tem…

  Charmer

  13 replies

  14 years ago

  By: Gail Shaw

• Case in Where Clause? Alternatives pls.

  Ok dudes and dudettes. I'm suffering from drain bramage today and I can't figure out a better way …

  CptCrusty1

  13 replies

  14 years ago

  By: Gullimeel

• Receiving and using a variable in an sql-statement (procedure)

  Is there any special way to receive a variable from a macro and put it into my sql-procedure... I'm…

  TheKasper

  6 replies

  14 years ago

  By: TheKasper

• Query SSAS Server Properties

  Is there a query that I can run against Anaylsis Services that will return the backup folder server…

  sidewinder6x

  1 replies

  14 years ago

  By: kwe477

• Database Mail Configuration

  Hi, I am setting up Database mail in SQL Server 2008 to send mail to my Gmail account. Following ar…

  vinu512

  10 replies

  14 years ago

  By: Suresh B.