SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Does EF4 reuse query plans?

  Does anyone have any experience with EF4 and the queries it generates? Someone from the application…

  vishal.gamji

  4 replies

  14 years, 10 months ago

  By: vishal.gamji

• Foreign key problem

  Suppose that we have lots of tables related to each other, with no cascading on delete. Is there a …

  Horatiu Ripa

  2 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Cannot restore database

  It seems I don't have the right permissions but I'm not sure where. I can search and find the file…

  Patti Johnson

  5 replies

  14 years, 10 months ago

  By: Patti Johnson

• Excessively Long Restore times

  Hi, I am attempting to restore two databases that are both approximately 78 Gb in size. Generally,…

  elstrom99

  7 replies

  14 years, 10 months ago

  By: Steve Jones - SSC Editor

• Prevent create procedure if the user does not have access to the procedure contents.

  User user1 has no access to the table dbo.Table1, but the user has access to vw.vTable1 which refer…

  gvarol

  3 replies

  14 years, 10 months ago

  By: gvarol

• COUNT(*) with WHERE variables too slow with 460 000 records table

  Is there a way to do COUNT(*) to run faster or rewrite alternative which will count number of recor…

  novak 32871

  12 replies

  14 years, 10 months ago

  By: Gail Shaw

• SQL servers are no longer visible on our network

  A large section of SQL servers are no longer visible on our network through either the browse or XP…

  MarvinTheAndriod

  14 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• Reindexing job vs Transaction log backup

  We have a full backup job and transaction log backup job for a server. Full backup job is running e…

  EasyBoy

  6 replies

  14 years, 10 months ago

  By: Syed Jahanzaib Bin hassan

• full table scan on partitioned table

  hi we have a 120G table and partitioned table into 30 partitions on based on a char(20) char field.…

  shen-dest

  9 replies

  14 years, 10 months ago

  By: LutzM

• Hoppa! Two brand new SQL Server for me! Now, how do I replicate data?

  Hi, I am a lucky DBA who has just got two new SQL Servers (both all latest OS, SQL-WebEdition). One…

  Raymond van Laake

  3 replies

  14 years, 10 months ago

  By: Raymond van Laake

• Dynamic SQL and IN Operator

  I am using dynamic sql to create a pivot table. The dynamic function accepts a sql query as a param…

  bubs

  22 replies

  14 years, 10 months ago

  By: Jeff Moden

• Generating query files named based on contents of table

  Hey all, I am trying to design a table to manage replication ranges between servers. I would like t…

  SQLUserC

  3 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Must declare the variable '@Name' issue

  I do not know if I am in the right thread, but I am having a SQL issue. When I debug my web-page i…

  dianaansari

  8 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• T-SQL to show Row Counts for all Tables

  Hello Everyone Hope all is well. I am trying to write some code to query all user tables to get the…

  AndrewSQLDBA

  4 replies

  14 years, 10 months ago

  By: Dan.Humphries

• going crazy with update statement! Plz help

  hi everybody, I have a big problem with update statement, let me mention the situation by exact scr…

  simorgh.software

  11 replies

  14 years, 10 months ago

  By: tfifield