SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Configuration Manager; nothing under SQL Server Services

  Honestly, I give up. I can't connect to this database as sa ('a network-related or instance-specifi…

  Beatrix Kiddo

  12 replies

  1 month, 3 weeks ago

  By: Srinivas Merugu

• normal role member to be able to view list of other role members in his DB

  Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and [sys].[…

  Senad

  2 replies

  5 months ago

  By: Ant-Green

• DBCC SHRINKFILE failing with error Msg 3140, Level 16, State 5, Line 1, Could not adjust the space allocation for file

  Hi, I am trying to run SHRINKFILE on one of our data files but it is failing with error "Msg 3140, …

  greg.huxley

  12 replies

  5 months, 2 weeks ago

  By: WAL

• why cant we take regular full backup on secondary replica?

  Good Morning Experts, In Alwayson Availability Groups, why cant we take regular full backup on seco…

  coolchaitu

  20 replies

  7 months ago

  By: Sujith Pillai

• Stupid Question: Return Object Explorer to It's original position

  Stupid question but I accidentally moved object explorer from it's original default position on SSM…

  Like2SQL

  27 replies

  2 years, 7 months ago

  By: adi9993

• Initial SQL Server Configuration is not working.

  I'm working with Server 2008 R2 which has just been installed. I'm new to everything administrative…

  techvishal11

  2 replies

  2 years, 7 months ago

  By: techvishal11

• SQL Server Standard Question

  We are looking to purchase SQL Server Standard 4 Core and from what I have seen the price is right …

  JeffRo

  1 replies

  2 years, 8 months ago

  By: Michael L John

• alias the name of pivoted columns

  How do you alias the CA to California and MN to Minnesota and still have 0s and 1s as the results S…

  cocopuffs

  2 replies

  2 years, 10 months ago

  By: Steve Collins

• Need to provide access to database without giving access to production

  Hoping I could find some best practice answers here: We have analysts who need to query and manipul…

  gray6

  1 replies

  2 years, 11 months ago

  By: ratbak

• pivot query issue

  I got my query working mostly but would like to add a row total at the end in the pivot here is my …

  zenloki

  2 replies

  3 years ago

  By: zenloki

• sql tutorial for beginners

  Any buddy reply me, if they are having good resource for sql tutorial for beginners, though i have …

  fvcdata

  5 replies

  3 years, 1 month ago

  By: Jeff Moden

• Data Masking with a large database - How are others doing this efficiently?

  Hi, I'm looking to take a database that is a copy of a 100+ gb production database with over 1,000 …

  tarr94

  3 replies

  3 years, 2 months ago

  By: Michael L John

• Unable to append strings to record from SELECT Statement

  Hi All,   Just had another newbie question, I practiced some sql commands on the w3 schools sa…

  Imrans23

  9 replies

  3 years, 2 months ago

  By: Jeff Moden

• Using Results from CASE Statement to create a calculated Field

  Hey all, Sorry for asking so many questions, but I'm usually not able to easily find solutions to t…

  Imrans23

  3 replies

  3 years, 3 months ago

  By: Jeff Moden

• Will my Query affect any rows in the DB??

  Dear All, Hope you are doing well. I am really new to SQL and was wondering whether anyone could ju…

  Imrans23

  4 replies

  3 years, 3 months ago

  By: Imrans23