SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• What is kept in transaction log and what is not?

  Hello all, Does transaction log stores some information about transactions that has been actually …

  AivarsH

  11 replies

  14 years ago

  By: AivarsH

• Isolating the last instance of an entry from a large table with multiple joins

  We've got a database dump from a case management system. In some DW I'm doing in my first few days…

  Atyeo9

  3 replies

  14 years ago

  By: Atyeo9

• Restore backup from BAK file i have new data

  hi i did some major changes to data in a DB ,so before i did it i did a full backup via the SQL Se…

  moshe.rosenberg

  1 replies

  14 years ago

  By: Usman Butt

• SSMS Query behavior question

  I have a table with 200,000,000 records. It contains a date field. When I query the table using a "…

  mpdillon

  5 replies

  14 years ago

  By: mpdillon

• Check Constraint on boolean

  Hello, I have to implement an active/inactive field on a table as we cannot delete the records. So…

  Scaramouche

  7 replies

  14 years ago

  By: Sean Lange

• self teaching newbie needs help please...

  Hi Have some questions on a project I'm working on: I am using SQL Server Management Studio 2008 I…

  ajk825

  7 replies

  14 years ago

  By: ACinAZ

• Need Help..Linked Server Monitor?

  Just a little introduction. I'm not even a newbie. I'm getting thrown to the wolves on a linked s…

  acorrei1

  2 replies

  14 years ago

  By: Ignacio A. Salom Rangel

• INT or Decimal

  Is there anyway to findout if passed parameter is INTEGER or DECIMAL(NUMERIC)?

  Walton

  10 replies

  14 years ago

  By: JonFox

• PLease help with a count problem

  Im still learning the basics. Im trying to see in this database how many people are registered at t…

  emdavies82

  7 replies

  14 years ago

  By: JonFox

• SQL JOins to retrive the results

  I have to reireive the users with systemflag set to 'N' tables: 1. table cmbusr(Only users with rol…

  MVIT

  4 replies

  14 years ago

  By: ghanshyam.kundu

• database size

  what would be the size of the database in real time in sql server and size of the data ware house. …

  pavithrareddyc

  11 replies

  14 years ago

  By: PaulB-TheOneAndOnly

• SSRS question !

  Hi Im a newbie with SSRS deveopment but i at work i need to develop some reports for which i reviwe…

  abcuser

  2 replies

  14 years ago

  By: SQL_path

• Extracting records with the latest date

  I need assistance in constructing a query that will extract record(s) that have the "latest date". …

  nfpacct

  9 replies

  14 years ago

  By: Lynn Pettis

• Restoring with NORECOVERY query executes indefinitely

  I am trying to set up mirroring, and when I restore the database to the mirror server using the 'NO…

  thotvedt

  3 replies

  14 years, 1 months ago

  By: Ignacio A. Salom Rangel

• Lawyer Landlord, Lawyer for Landlord

  NYC Landlord Tenant Litigation Practice of Robert Aronov, Esq. incorporates such services as lease …

  tonymia55

  1 replies

  14 years, 1 months ago

  By: Gail Shaw