SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Performance issue with subquery containing row_number and partitioning

  Hi, I'm developing a query that does what I want it to, but takes a long time to run. I thought I'…

  tarr94

  4 replies

  11 years, 1 months ago

  By: Daniel Matthee

• SQL Server 2014 Management Studio Backup

  I have figured out how to do a manual backup. How would I setup an automatic proceedure? TY mary

  mguyder

  3 replies

  11 years, 1 months ago

  By: HanShi

• Review on SELECT query

  In my select query, I have a part where I have written like SELECT A.activityCode ,A.ActivityNam…

  VSSGeorge

  8 replies

  11 years, 1 months ago

  By: Luis Cazares

• Backup and save a copy on a server on a different domain

  Hi I would like to set up a daily job that backs up the database and transfers a copy of the backup…

  M.DBA

  15 replies

  11 years, 1 months ago

  By: Nataraja Sidgal

• White Space in fields??

  I am having an issue where white space is consistently being added to fields in a SQL DB (2008). Al…

  jlandry

  4 replies

  11 years, 2 months ago

  By: Ed Wagner

• Can I configure LogShipping on same machine using two different Instances ?

  Hello, Can I configure Log Shipping on same machine using two different Instances ? I have one Mach…

  jitendra.padhiyar

  3 replies

  11 years, 2 months ago

  By: djj

• SQL development

  Hi All, As I'm fairly new to the game, can anyone recommend any good sql books for progressing in t…

  imran.shah

  4 replies

  11 years, 2 months ago

  By: imran.shah

• How to bulk delete stored procedures from a pattern

  Hi all! I have app. 1000 stored procedures named: Easy_UpdateSchemaTemp_17311230631246784 where the…

  Edvard Korsbæk

  5 replies

  11 years, 2 months ago

  By: Lynn Pettis

• Help Newbie here, new to sql

  Hi All, I'm a novice when it comes to sql programming and hoping someone can help me with my scenar…

  imran.shah

  22 replies

  11 years, 2 months ago

  By: Meet George Jetson

• Books on SSRS 2008R2 - emphasis on reporting

  Dear all This is very open-ended I'm afraid so apologies if it breaks question guidelines. However,…

  faulknerwilliam2

  2 replies

  11 years, 2 months ago

  By: kapil_kk

• to preserve line breaks

  Hi all, I can't seem to find a solution to the following. I have a front-end page where user types …

  RightOnTarget

  4 replies

  11 years, 2 months ago

  By: Luis Cazares

• New to site

  Hi Guys, I'm so glad I found this site. I really want to learn MS SQL. Lots of information on this …

  rym2001

  4 replies

  11 years, 2 months ago

  By: Grant Fritchey

• trigger

  I need some help and i too new to SQL. How to i create a Trigger to enforce this constraint: A rent…

  hillerz19

  5 replies

  11 years, 2 months ago

  By: Jeff Moden

• Help with large table update and insert

  We have a report package that is downloaded by customers and then it is periodically updated as we …

  thomashohner

  9 replies

  11 years, 2 months ago

  By: thomashohner

• Directional indicators part two

  Hello I have a report which shows month in one column and value in the next, eg: Jan 200 Feb 250 Ma…

  faulknerwilliam2

  4 replies

  11 years, 2 months ago

  By: faulknerwilliam2