SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Noobie Question: GetDate() in UDF

  Hi everybody, I always thought that 1) non-deterministic functions weren't allowed in user-defined…

  Dennis-509860

  2 replies

  14 years, 7 months ago

  By: Dennis-509860

• Strange behavior with selecting random rows

  Hi All, The problem i'm trying to solve is randomizing data in one of our tables, and I am trying…

  john-from-ct

  22 replies

  14 years, 7 months ago

  By: john-from-ct

• Updating text valued(varchar) column with better performance

  I have around 15 columns in the table.. In that two columns has varchar(6000) data type. Here the t…

  bvsc

  21 replies

  14 years, 7 months ago

  By: Welsh Corgi

• Upgrade Windows Server 2003 to 2008

  Can anyone out there provide me information or white papers regarding the benefits or disadvantages…

  BobMcC

  5 replies

  14 years, 7 months ago

  By: BobMcC

• how to search containing word using "Free Text Search" like %[word]%

  Hi, Is it possible to search the middle word using free text query similar to %[word]% using in T…

  Vijay A

  2 replies

  14 years, 7 months ago

  By: Vijay A

• Stored Procedure

  Hi All, I have a stored procedure, which contains more than 10 queries. and its taking long time to…

  Raghavender Chavva

  1 replies

  14 years, 7 months ago

  By: Ninja's_RGR'us

• Plot graphs from SQL table

  Is there a tool which takes the XML file from SQL and plots a graph on webpage? I could plot graph …

  jaya

  3 replies

  14 years, 7 months ago

  By: jaya

• FTP TASK

  Hello, I have this task to accomplish Please take last night’s full backup and convert it to a stan…

  sahoong

  2 replies

  14 years, 7 months ago

  By: sahoong

• Shrinking Log files

  Hi , I tried running the commands to shrink log files but i am getting the errors and the file also…

  Achilies

  15 replies

  14 years, 7 months ago

  By: Ignacio A. Salom Rangel

• dbo rights to disabled sql login

  Hello, On the sql server, sql authentication mode is disabled. The db are mirrored. When I tried d…

  khushbu

  4 replies

  14 years, 7 months ago

  By: khushbu

• Cache file

  MSCLUSTERSQL_MSSQL10_50.MSSQLSERVER_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_4.cache ı have in sql se…

  ESAT ERKEC

  1 replies

  14 years, 7 months ago

  By: ESAT ERKEC

• BCP command to import data from txt file (Pipe as Field terminator)into SQL Table.

  Hi all I am facing hard time in configuring the BCP command to to import data from txt file (Pipe …

  anand_vanam

  4 replies

  14 years, 7 months ago

  By: anand_vanam

• Using SSIS

  I am migrating data from one database to another database, I am showing you the Input data, and the…

  kishoremania

  15 replies

  14 years, 7 months ago

  By: kishoremania

• Linked Server error

  Hello All, I am executing a stored procedure that exists on a SQL Server 2008 server from a SQL Ser…

  Chrissy321

  3 replies

  14 years, 7 months ago

  By: Evil Kraig F

• Testing box for sql servers

  I would like to do some testing on a testing box for installation. Our production server will be en…

  sqlfriend

  14 replies

  14 years, 7 months ago

  By: Ron McCullough