SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Query Performance - CTEs verses Derived Tables - Which Is Better And When

  If I have a query that contains 5 SELECTs that are UNION'd (via UNION ALL) and each of the % has th…

  YSLGuru

  2 replies

  14 years, 6 months ago

  By: YSLGuru

• Database Mirroring with multiple databases

  Hello I am looking into database mirroring but I am a little confused about how this works if you h…

  Graham Macfarlane

  7 replies

  14 years, 6 months ago

  By: markmar1

• SQL replicating / sync

  Hi, I am in a situation where I am in need of setting up some form of SQL 2005 backups from one ser…

  sc-w

  1 replies

  14 years, 6 months ago

  By: Sean Lange

• Monitor SP Parm Lengths

  Hello, We are trying to get an idea of the avereage length of a parameter being passed in. Currentl…

  nfs_john

  4 replies

  14 years, 6 months ago

  By: nfs_john

• Adding Column to Large Table

  I know this has been asked before. And I did peruse the forums but couldn't reach any conclusion. I…

  Pagan DBA

  18 replies

  14 years, 6 months ago

  By: Cadavre

• Combine rows and aggregate VARCHAR column using Comma

  Hi all, I have the following scenario: Col1 Col2 Col3 Col4 SD 23 UY 14 SD 23 XV 14 FD…

  Husain_Kachwala

  1 replies

  14 years, 6 months ago

  By: Dave Ballantyne

• Stored procedure naming prefix

  Hi I've noticed at our company stored procedures gets prefixed with "sp" and not "sp_". My questio…

  l0n3i200n

  13 replies

  14 years, 6 months ago

  By: Roy Ernest

• SqlServer Stored Proceedure

  Hi all, Sorry if this is wrong place to write... My question is .. i do have a stored procedure whi…

  MuhammadShafiq

  1 replies

  14 years, 6 months ago

  By: LutzM

• Which type of index to use??

  Hi All, I need one help in deciding index to be used in my table. I have a table with around 200,00…

  sam 55243

  1 replies

  14 years, 6 months ago

  By: Gail Shaw

• Profiler Template of 2000 to 2005

  Hi, I have a problem regarding templates in profiler of 2000 to 2005. I am unable to open 2000 Tem…

  dineshpl2001

  1 replies

  14 years, 6 months ago

  By: Arun Benjamin

• I forget the sql server 2005 user Name and password

  🙂 I forget the sql server 2005's user Name and password Now how to connect It

  rajesh_somvanshi

  3 replies

  14 years, 6 months ago

  By: Uripedes Pants

• Is there a better way to build discretization buckets

  than just murderlizing them into a table? granted, the scheme is slightly irrational, but something…

  drew.georgopulos

  6 replies

  14 years, 6 months ago

  By: drew.georgopulos

• Creating a dynamic date parameter in a SQL Reporting Services 2005 subscription

  Hi I wanted to know if anyone is aware of creating a dynamic date parameter in a SQL Reporting Ser…

  hardiboy1431

  1 replies

  14 years, 6 months ago

  By: pkettley

• Sql Server Broker Starting Conversation but not Passing to remote server

  Hi chaps and chappettes. I am in the process of configuring a server broker solution between a loc…

  phillipwatson1976

  1 replies

  14 years, 6 months ago

  By: LutzM

• Percentage not correct

  I have this small script, and now all I am needing is the percent from num_participants/num_Meeting…

  kstephens 90242

  3 replies

  14 years, 6 months ago

  By: GSquared