SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• temp DB is full

  Hi all. Please let me know what needs to be done in below scenario. TempDB is full. Unable to expan…

  laxmanmachineni

  2 replies

  10 years, 11 months ago

  By: Jeff Moden

• Best training resource test preparation for Exam 70-461?

  I am preparing to take the 70-461 Querying SQL exam. Does anyone have suggestion for the best and m…

  dariuslearn

  4 replies

  10 years, 11 months ago

  By: dariuslearn

• Best approach to download variably named CSV file from FTP and insert into existing table?

  I need to create a daily transaction that does the following: 1: Downloads a file from a client's F…

  Herpington_McDerpington

  17 replies

  10 years, 11 months ago

  By: Herpington_McDerpington

• Best Approach

  I am trying to display various activities in the table through a Query . What will be the best way …

  sharonsql2013

  5 replies

  10 years, 11 months ago

  By: Xedni

• Scalar Function to determine last date for 4 different rule conditions - Final step - 4 Date Variables - what is latest

  Thanks to this site, my DB project (SQL Server back end with MS Access Front End) has been transfor…

  Mile Higher Than Sea Level

  19 replies

  10 years, 11 months ago

  By: Lynn Pettis

• SQL Query app not working correctly (SQL , Access, java)

  Hi Guys, my console SQL Query app is not giving me the desired output. I am sure its might have som…

  reignbuckingham

  3 replies

  10 years, 11 months ago

  By: Gail Shaw

• char(n) v varchar(n) - data type length question

  Hi experts, I posted this question in the DB design forum but this forum seems more active and appr…

  gleb 43933

  6 replies

  10 years, 11 months ago

  By: Jeff Moden

• Query to show the names of the ServiceTypes that have more customers via Web form than Telephone

  Hello, I can write basic queries but am struggling with this. In a table of: Table: Production Ser…

  blooddragonarmour

  2 replies

  10 years, 11 months ago

  By: blooddragonarmour

• Insert/Update trigger

  I have a table (Table A) where users input items with their corresponding job numbers. Sometimes us…

  sKreetz!

  1 replies

  10 years, 11 months ago

  By: Xedni

• How to check effect of insert statement during debugging of stored procedure

  I am debugging a stored procedure. During this I am executing some insert statements on a table wh…

  SAMDEV

  7 replies

  10 years, 11 months ago

  By: Sean Lange

• search date field by partial date?

  on one of my tables I've a field set as smalldatetime, which is populated by various dates ranging …

  mick burden

  7 replies

  10 years, 11 months ago

  By: mick burden

• Error Log issue

  Hi All, I am getting error message in error log "Message [LOG] Unable to read local eventlog (reaso…

  arooj300

  4 replies

  10 years, 11 months ago

  By: arooj300

• New to SQL. Need help

  Hi I have to create a table with the following Accountnumber,DOB,FullName,Accountopendate,currentb…

  OwnSQL

  3 replies

  10 years, 11 months ago

  By: Jeff Moden

• Struggling with query to retrieve five most recent

  Hello, I'm struggling with a particular query and would greatly appreciate any help on this. My tas…

  tarr94

  8 replies

  10 years, 11 months ago

  By: tarr94

• Understanding Transaction log sizes

  I have a SQL Server database that is 5 GB. The transaction log seems to keep growing. It is 1.4 GB …

  rummings

  12 replies

  10 years, 11 months ago

  By: KenpoDBA