SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Just taken new Job as a SQL Server DBA, can anyone recommend some learning material?

  I come from a SQL developer background but have now taken a position as a DBA. Recovery plans , sec…

  bugg

  7 replies

  13 years, 3 months ago

  By: Ed Wagner

• Return rows with youngest DateTime

  I have a dataset for a ticketing system. The dataset contains the Ticket #, Assigned Technician, an…

  jagnew

  2 replies

  13 years, 3 months ago

  By: jagnew

• Stored Procedures and updating multiple tables

  Was hoping someone could kick me in the right direction in regards stored procedures. My issue is i…

  flebber.crue

  5 replies

  13 years, 3 months ago

  By: flebber.crue

• Loop through table to group associated records

  Hi All, I have a table containing about 1mil records that i need to loop through, find associated r…

  scarlam

  6 replies

  13 years, 4 months ago

  By: ChrisM@home

• Calculating AGE with 2 INT columns

  Hi, Can someone help me with this query? I have two columns both are INT and have dates stored in t…

  scribesjeff

  7 replies

  13 years, 4 months ago

  By: Luis Cazares

• Linked Server shows table but does not retrieve data

  Hello everyone, I have two database server each X(SQL Server 2000) and Y(SQL Server 2008), I c…

  naqib_bs

  10 replies

  13 years, 4 months ago

  By: TomThomson

• The client was unable to reuse a session with SPID 157, which had been reset for connection pooling. The failure ID is 29.

  I am seeing more of these errors since we added the LYNC databases to our one Cluster instance. Thi…

  rummings

  2 replies

  13 years, 4 months ago

  By: CapnHector

• Column names in Results Pane - Fit to Width

  Is there a way to make the results of your query to auto-fit the headers? I just started a new job …

  SQL Wayne

  1 replies

  13 years, 4 months ago

  By: Sean Lange

• != NOT EQUAL TO Query

  I am trying to do a Not Equal To Query. I have multiple tables with numerous columns. All of the re…

  jbulldog

  11 replies

  13 years, 4 months ago

  By: jbulldog

• SQL query needed for locating specific text criteria

  Hi all, Been a long time since I did anything with SQL and would like your help on the following re…

  NadJ

  6 replies

  13 years, 4 months ago

  By: Lowell

• Convert DD-Mon-YYYY to DD/MM/YYYY

  Hi experts, I have a table called temp in which i have date columns as dt_of_birth [varchar](15),dt…

  arthi.anan

  4 replies

  13 years, 4 months ago

  By: ACinAZ

• create a type with default value/names

  I have seen some code somewhere long ago but cant find it anywhere now. something like create type …

  roy.tollison

  9 replies

  13 years, 4 months ago

  By: Sean Lange

• SQL Sever using much memory than allocated...

  Hello Masters, Currently my sqlserver.exe is consuming 12.4 GB of memory, which much more than Max …

  jitendra.padhiyar

  6 replies

  13 years, 4 months ago

  By: Gail Shaw

• Differential backup created without a FULL backup?!

  Good morning, I thought that the only way to create a differential backup is to have a FULL backup …

  Abu Dina

  8 replies

  13 years, 4 months ago

  By: Vegard Hagen

• Possible to list Tables SP with Roles and Permissions

  Hi all, Is it possible to list out all the tables/SP in a database and if a role has a GRANT on it…

  n00bDBA

  2 replies

  13 years, 4 months ago

  By: n00bDBA