SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SSRS 2nd page from 19 pages is blank

  I Was using SSRS 2008, I created SSRS report. After I moved to pdf, it shows me the second page is …

  mak12

  2 replies

  14 years, 4 months ago

  By: Possinator

• Using Full-Text to "match" rows in two different tables

  I'm hoping someone out there can lend some assistance and possibly tell me if this is even possible…

  Aryn

  3 replies

  14 years, 4 months ago

  By: 456789psw

• Add a comment for XML output from SQL using "FOR XML EXPLICIT"

  Input SQL Query declare @agent table ( AgentID int, Fname varchar(5), SSN varchar(11) …

  mmi 9526

  1 replies

  14 years, 4 months ago

  By: mmi 9526

• Testing Queries, OPTION(RECOMPILE) and TOP %

  I have a stored procedure that I'm trying to speed up. I've pulled the code from the stored procedu…

  Sioban Krzywicki

  17 replies

  14 years, 4 months ago

  By: Sioban Krzywicki

• Executing query

  Trying to learn sql7 When I write a query in Server Query Analyser, it executes fine. I create tabl…

  joeknas

  9 replies

  14 years, 4 months ago

  By: joeknas

• Any suggestion when batch requests reaches about 1000/sec, ?

  Hi Like to know what to do when the BatchRequest/Sec reaches above 1000/Sec . What step you taking …

  SQlLogic

  9 replies

  14 years, 4 months ago

  By: sturner

• Data compression with Log Shipping

  I think I posted this in the wrong thread....earlier! Greetings! I have been giving some thought to…

  anish_ns

  2 replies

  14 years, 4 months ago

  By: anish_ns

• help me with attaching database

  Hello. I have a problem with attaching DB. There is a DB that was detached from the instanse of SQL…

  pavluxaf

  5 replies

  14 years, 4 months ago

  By: Gail Shaw

• which databses are touched by maint plan

  i've been asked to provide a report of when every backup job run by the sql agent runs and what dat…

  NJ-DBA

  4 replies

  14 years, 4 months ago

  By: NJ-DBA

• Output as xml

  The following is from a view. I need to output the entire result set as xml, using FOR XML, but i'…

  wjhamel

  2 replies

  14 years, 4 months ago

  By: wjhamel

• Any way of verification

  Hi I need to deploy multiple SPs on mutiple DB on daily basic. I want to audit/confirm that wh…

  waseem.shahzad 45937

  3 replies

  14 years, 4 months ago

  By: Lowell

• Substring issue

  Hi, I want to return only the hour of a time ie 17:00 should return 17 The code below selects the t…

  mic.con87

  2 replies

  14 years, 4 months ago

  By: mic.con87

• SQL Server Best Practices to develop a standard base for all sql servers. Suggestions please!

  Have a general question what setting/s would a dba hold true to implement on all servers touched? i…

  oweston

  6 replies

  14 years, 4 months ago

  By: oweston

• Count(*) returning a lower figure than Count(Distinct columnname)

  Hi, I'm getting a very strange anomoly here. We have a table of roughly 28,000,000 rows. The schem…

  giles.clapham

  2 replies

  14 years, 4 months ago

  By: giles.clapham

• Registered Server List

  Does anyone know if it is possible to print out the structure of the registered server list? I hav…

  ggoble

  1 replies

  14 years, 4 months ago

  By: Jason Selburg