SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Buffer catch Hit ration

  Hi All, I am getting a alerts Buffer catch Hit ration 100% and when i check buffer manager deta…

  saidapurs

  5 replies

  13 years, 8 months ago

  By: saidapurs

• Import excel 2010 spreadsheet

  Hi I tried to import excel 2010 spreadsheet, but I can not find any option for 2010, higest version…

  @DJ

  3 replies

  13 years, 8 months ago

  By: Dwain Camps

• Use a variable as a column name - without dynamic SQL?

  CREATE TABLE #tblItems ( ItemID int, ItemDescription varchar(50), ItemDate …

  webskater

  3 replies

  13 years, 8 months ago

  By: webskater

• SQL Beginner

  I have a table in this format: Origin Destination Tonnage(Kton) AlabamaArizona 0.0012 Ala…

  shikhar_0511

  21 replies

  13 years, 8 months ago

  By: Gail Shaw

• filegroups and tables.

  How can I see which tables belong to a filegroup ? (A selection which gives me all tables belonging…

  ben.brugman

  1 replies

  13 years, 8 months ago

  By: Gail Shaw

• Why there is no SQLServer:BufferManager performance counter in windows performance monitor after installing sqlserver?

  Hi all, there is one strange problem. I have installed the sqlserver 2008 R2 on one windows 2008 se…

  Wison

  1 replies

  13 years, 8 months ago

  By: Ben Miller

• Running a TSQL type job (not SSIS) through Proxy

  I have an job which has SQL queries and Stored procedures. Can this step be run through an proxy ac…

  balasach82

  7 replies

  13 years, 8 months ago

  By: belvdr

• Can you recover SQL Authentication password?

  All, If a user forgot his/her SQL Authentication password, is there anyway a DBA can recover that p…

  SQLisAwe5oMe

  4 replies

  13 years, 9 months ago

  By: SQLisAwe5oMe

• transaction cannot be committed

  Dear Experts, What happen with my transaction below. I am getting this error. (Somehow I can't post…

  haiao2000

  15 replies

  13 years, 9 months ago

  By: haiao2000

• Filtering a database based on instr rules

  Hi All, I have 2 database. The first database has 20 columns and 40000 rows. The first database loo…

  c.vaibhav

  1 replies

  13 years, 9 months ago

  By: c.vaibhav

• microsoft certification dba

  hey I want to become sql dba certified whats the best route? thanks

  erics44

  7 replies

  13 years, 9 months ago

  By: Gail Shaw

• FInding Text Box properties to remove duplicate values

  I created a report that was pretty functional, but I had to move a column over to the right for cla…

  cljolly

  6 replies

  13 years, 9 months ago

  By: cljolly

• Nested Loops Joins

  Hi I have been lokoing at Nested Loop Joins and i probably dont fully understand them but how can t…

  erics44

  8 replies

  13 years, 9 months ago

  By: erics44

• How to make Business Intelligence Development Studio appear?

  I installed SQL 2008 R2 first and then VS2008. I can not find SSIS available in start, all programs…

  adonetok

  2 replies

  13 years, 9 months ago

  By: demonfox

• SQL Query for reporting.

  having a reporting situation. create table CustTable (Customer varchar(10),Location varchar(10)) i…

  gravitysucks

  3 replies

  13 years, 9 months ago

  By: rVadim