SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Stored procedure very slow execution

  Hello, Please help me, I'm desperate. I have an old SQL2000 (SP4) - and no, I can't upgrade it, is…

  Radu Costescu

  29 replies

  13 years ago

  By: Radu Costescu

• query help

  Hi all, [SQL Server 2008R2] I have 2 tables on different servers that I need to keep in-sync. I hav…

  RightOnTarget

  3 replies

  13 years ago

  By: Sean Lange

• SQL Server login Server Roles needed for Backup Exec User

  SQL 2008r2 ---- Windows Server 2008 Standard I want to create a new SQL server login to allow Bac…

  jane.simmons

  3 replies

  13 years ago

  By: Ed Wagner

• changing a sql 2005 developer license to production

  I have a windows 2003 server running sql 2005 with a developer license installed. It's now in prod…

  davery 28734

  2 replies

  13 years ago

  By: Orlando Colamatteo

• Database in Recovery

  Hi All I had a situation where my SQL Server was stopped in the middle of a long running transactio…

  SQLSACT

  5 replies

  13 years ago

  By: dbafromthecold@gmail.com

• Secondary indexes in SQL Server.

  Hi all, What are secondary indexes in SQL Server and why are they needed.

  Shadab Shah

  6 replies

  13 years ago

  By: dbafromthecold@gmail.com

• IIF-function gives errors

  Folks, I am using SQL Server 2012 Express Edition and want to make use of the new IIF-function. I a…

  r_slot

  3 replies

  13 years ago

  By: r_slot

• Pivot results not as expected

  I have a select statement as below: SELECT Institution_Number, Attached_Account_Number, [1], [2…

  jillk

  1 replies

  13 years ago

  By: Dwain Camps

• when to defragment indexes

  Hi All, I understand that indexes need to be defragmented when they get fragmented, however must on…

  ugo boy

  6 replies

  13 years ago

  By: sqlnaive

• query to list linked server user

  Hi How do i query the SQL server to list the "remote login" of a linked server? it sounds so simple…

  jCoke

  3 replies

  13 years ago

  By: Gazareth

• how to attach database with variable path by storedprocedure??

  please help me, how to attach database with variable path??

  taufikalfarisi

  2 replies

  13 years ago

  By: taufikalfarisi

• Trigger on insert

  Hi , I have a requirement where i have a table (EMP) with fields id, name, status What i want is …

  rajasekhar.cn

  3 replies

  13 years ago

  By: Ant-Green

• Is this the best way to obtain the records in specific TIMEFRAME in the MS SQL statement?

  Hello, I would like to locate the records within specific timeframe from a Friday prior week to las…

  Tamrak

  2 replies

  13 years ago

  By: Tamrak

• Sys.dm_db_partition_stats table?

  I was looking this morning for a way to find the row count of all of the tables in one of our datab…

  DataAnalyst011

  1 replies

  13 years ago

  By: jasona.work

• SQLCMD question (extract to csv file)

  I was asked to create a batch file for a non-techie type so that all they have to do is key in a da…

  J M-314995

  1 replies

  13 years ago

  By: Orlando Colamatteo