SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Many tables versus one table

  This may ignite a firestorm of passionately held beliefs, but I'd still welcome hearing some opinio…

  pdanes2

  8 replies

  15 years ago

  By: pdanes2

• When to use full-text

  Are there any guidelines on when it is advisable to add full-text capabilities to a database? Numbe…

  pdanes2

  9 replies

  15 years ago

  By: GSquared

• Replication Pull subscription from SQL Express

  Hi all, I have to use Snapshot replication to around 20 SQL Express clients across out network. I…

  Staggerlee

  3 replies

  15 years ago

  By: Roy Ernest

• Remote Connection and 2008 r2 sp1

  Driving me nuts here.. Installed 2008 r2 then upgraded to SP1. Remote connections are enabled SQL…

  Staggerlee

  13 replies

  15 years ago

  By: Ignacio A. Salom Rangel

• Dynamic Pivot Columns for Changing column starting points

  I would like to see if there is a way to overcome my issue using Dynamic Pivot (have SQL Server 200…

  flam

  20 replies

  15 years ago

  By: flam

• selecting dataset with row numbers

  There are functions in newer versions that would solve my problem, but unfortunately we are still u…

  rice.tx

  16 replies

  15 years ago

  By: Orlando Colamatteo

• Selecting Max(ID)

  Let's say I have a simple table as follows: declare @TestTable table ( ID int, EmployeeID int, Sala…

  bubs

  8 replies

  15 years ago

  By: The Dixie Flatline

• Returning Object_Name or name of tbl

  I'm looking to return the table name for an object_id from the sys_dm_db_index_physical_stats. How …

  Jonathan Marshall

  5 replies

  15 years ago

  By: SQLRNNR

• Selecting Conditional Totals

  I have what is probably a simple select statement for anyone who has experience writing sql. Given…

  meichner

  10 replies

  15 years ago

  By: Ninja's_RGR'us

• SQLXML Error 6969: ID/IDREF validation consumed too much memory.

  Hi all, When trying to populate an XML field from a large file, I received the following error (696…

  ed_ward_graham

  2 replies

  15 years ago

  By: ed_ward_graham

• SQL REPL Error.

  I get the following error: Executed as user: [DOMAIN]\Administrator. (unknown security error). The…

  gfilby

  3 replies

  15 years ago

  By: gfilby

• CURRENT_TIMESTAMP vs GETDATE()

  Hi I googled and everybody is saying that there is no difference between the CURRENT_TIMESTAMP and…

  BinaryDigit

  5 replies

  15 years ago

  By: David.Poole

• Why is the sum of allocation_units always less than the physical mdf file size?

  Hello, I'm working on a way to anticipate when a database is nearing the threshold for autogrowth t…

  mzaremba

  2 replies

  15 years ago

  By: SQLRNNR

• Companies that use SQL Server !

  Hi all , Please suggest me what's plus points of SQL Server compared to ORACLE,whats t…

  sawan1209

  16 replies

  15 years ago

  By: Michael Valentine Jones

• Ignore row if the one of the codes is null

  I have a data set Num RCode Date Code MaxCode 12 'R1' '12/1/2010' …

  sqlsdev

  1 replies

  15 years ago

  By: sqlsdev