SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Word Doc in SQL Server!

  Hi All I wish to store a word document in SQL Server. I should be able to search on the content. e.…

  S_Kumar_S

  2 replies

  11 years, 10 months ago

  By: aframiller326

• Max Value even for negative numbers

  Hi, Can anyone help me with this. I need to find the max value among 4 numbers in SQL. I tried usin…

  deepujagan

  10 replies

  11 years, 10 months ago

  By: deepujagan

• Data Migration from 2005 - 2008

  Hello all, I am a MID to SENIOR developer, but I have limited expertise in migrating data. Could so…

  Lord Slaagh

  2 replies

  11 years, 10 months ago

  By: Lord Slaagh

• Enabling CDC for hundreds of databases on one instance, do or do not?

  Hi all, I've been given an interesting topic to think about recently in the company I work for. Nam…

  tomes12

  8 replies

  11 years, 10 months ago

  By: tomes12

• It is possible to manually alter the filter_clause at sysarticles?

  Hello all I have a huge replication that takes days to be generated, many sources and hundreds of m…

  ricardo_chicas

  2 replies

  11 years, 10 months ago

  By: ricardo_chicas

• Shrinking Log file.

  In my prod database 'log_1' file is 161GB with only 5% space used. Can I take logbackup Dbcc shrink…

  Tac11

  3 replies

  11 years, 10 months ago

  By: Grant Fritchey

• Change display of result set from 'showing data as rows, to showing data as one or more columns'

  Hi Everyone, I am interested in changing the way that data is displayed in my result set. Essential…

  david.dartnell

  2 replies

  11 years, 10 months ago

  By: ChrisM@Work

• estimated execution plan

  Hello Experts, Can the estimated execution plan option give a rough estimate of how much time a que…

  rajsin7786

  3 replies

  11 years, 10 months ago

  By: Grant Fritchey

• MS CRM 40Gb table, 47k rows

  Hi, We have an installation of Microsoft CRM 2011 on SQL 2008 R2. There is a table which only has 4…

  jend

  8 replies

  11 years, 10 months ago

  By: jend

• What's using my memory!

  Hi all, I'm trying to decipher the myriad figures available for memory usage and need some help. M…

  webtekkie

  6 replies

  11 years, 10 months ago

  By: webtekkie

• Getting error while running the dynamic sql section ...assuming the where condition is wrong

  DECLARE AllDatabases CURSOR FOR SELECT name FROM master.dbo.sysdatabases WHERE dbid > 4 OPEN All…

  SQL_Hunt

  3 replies

  11 years, 10 months ago

  By: Gail Shaw

• Urgent help needed..PLZ HELP ME..

  Hi everyone.. I got patient_table columns [patnt_no],[patnt_refno] ,[admit_date],[discharge_date] …

  vasugunda

  23 replies

  11 years, 10 months ago

  By: David Burrows

• SQL Server Profiler and Excel VBA

  Hi, I have an Excel VBA ( developed by someone else ) that establishing a connection to SQL Server …

  davidku

  3 replies

  11 years, 10 months ago

  By: Koen Verbeeck

• Please help me to write trigger for update on single column

  Hi, I have table "project" as below ProjNum E0E1E2 1234.0 90100 200 1234.1 …

  Bals.Prasanna

  5 replies

  11 years, 10 months ago

  By: Bals.Prasanna

• Insert information based on a range

  I am trying to insert a bunch of data based on a ranger. Someone passes me starting range = OD1-200…

  cdl_9009

  8 replies

  11 years, 10 months ago

  By: Luis Cazares