SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• VARCHAR lat and long data fails when converting to NUMERIC, yet ISNUMERIC never returns 0

  Hi All: This one has me stumped! I have lat and long data that comes in as VARCHAR. Some rows have…

  DavidL

  16 replies

  12 years ago

  By: mickyT

• Passing huge parameter to linked server

  Hi, I have two SQL Servers L1 & L2, I am trying to delete data from one of the base table in L…

  SriSun

  1 replies

  12 years ago

  By: SriSun

• Query that returns SUM of column based on other data in other column

  I have what I thought was a simple query but turning into a bit of a mess... I have a table: CREAT…

  jamie_collins

  2 replies

  12 years ago

  By: jamie_collins

• Performance Monitor use!!!

  Just like to know which performance Monitor tool you guys use to monitor SQL server such as, Data c…

  Dan121

  3 replies

  12 years ago

  By: SQLRNNR

• Transaction log file growth tracking!!!

  I am trying to find out what time and how much transaction log file grows during a day even a week …

  Dan121

  3 replies

  12 years ago

  By: Adi Cohn-120898

• Reassign SQL Server 2008 R2 Per proc licensing to per cal licensing

  Our company was audited Now we need to change the licensing on one of our SQL Server 2008 R2 from p…

  domstrad

  1 replies

  12 years ago

  By: Steve Jones - SSC Editor

• Performance Tuning a query running since more than 13 minutes

  [font="Comic Sans MS"]I am desperately looking for some measure to tune this query, as this is used…

  Feivel

  16 replies

  12 years ago

  By: Sean Pearce

• Exec command in Sqlserver 2008

  This code says 'Could not find stored proc' Plz help declare @a nvarchar declare @b-2 nvarchar …

  Priya004

  3 replies

  12 years ago

  By: Sean Pearce

• Divide two columns with null values

  Hi, I am trying to divide these two columns and need suggestions. parsename('$'+ Convert(varchar,Co…

  vigneshkumart50

  1 replies

  12 years ago

  By: Koen Verbeeck

• Help with switch partition

  I have a partitioned table but there are some non-partitioned indexes in the table. When I tried d…

  N_Muller

  12 replies

  12 years ago

  By: N_Muller

• Replication wont die, wont go away

  Hello, I have (or had) Transactional Replication configured, from one SQL 2008R2 cluster to a SQL …

  MiguelSQL

  3 replies

  12 years ago

  By: MiguelSQL

• SSIS - FTP Task and SQL Agent Job

  Hi everyone I have created a SSIS Package that gets a list of files on a FTP site, receives and the…

  Jako de Wet

  8 replies

  12 years ago

  By: krishna.ravula

• Need help on indexes

  Hi , I need help on indexes, please view the attached file and let me know which index Should we ke…

  Sana4u

  12 replies

  12 years ago

  By: SQLRNNR

• db owner

  We have many in house or vendor based applications and their databases. I have a question about the…

  sqlfriend

  18 replies

  12 years ago

  By: dan-572483

• Scheduled Jobs Not Running

  Hello all. I am having trouble with SQL Server Agent on an instance of SQL 2008 R2. The agent appea…

  danchard

  2 replies

  12 years ago

  By: SQLRNNR