SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• float vs int

  Which one is faster in data reterival float or int Difference in float (4 to 8 byte)vs int (4 byte)…

  yuvipoy

  18 replies

  12 years ago

  By: TomThomson

• Are there security issues with SQL Authentication for a read-only account?

  Hello, I am advocating that the DBA of my organization create a read-only, least-privileged account…

  cafescott

  13 replies

  12 years ago

  By: djj

• xp_readerrorlog pegging the CPU

  We have 14 active spids the are executing xp_readerrorlong that have been running for several days.…

  Jeff Mayer

  8 replies

  12 years ago

  By: Tim Hiller

• Incorrect sequencing of row nos.

  Hi The following code outputs the data below the code (I have only included the relevant fields): …

  Canazei65

  4 replies

  12 years ago

  By: Canazei65

• INSERT MULTIPLE COLUMN DATA

  Dear Sir, How to insert the dynamic Values of the variable named @name in the below mentioned query…

  Subrata Bauri

  2 replies

  12 years ago

  By: Subrata Bauri

• sp_updatestats 0.3% sample?

  Hi guys, There is a job running sp_updatestats over night. This appears to collect based on 0.3% of…

  Dird

  3 replies

  12 years ago

  By: andrew gothard

• Disk Usage by Top Tables

  Hi All I have a query to resolve/understand how it all works. I have a table with 363 287 records, …

  smthembu

  6 replies

  12 years ago

  By: smthembu

• sql server 2008R2 as instance for SSIS 2012 console db

  Has anyone attempted to use sql server 2008 as the instance to put the ssis 2012 console DB? We are…

  jboles 79368

  1 replies

  12 years ago

  By: dan-572483

• Remove errant readings

  I have an ETL that imports readings from a flat file. The ReadingDate on the data is always good, …

  sqlpadawan_1

  3 replies

  12 years ago

  By: sqlpadawan_1

• Indexes without a name??

  Hello all, I've written a little .net program that loops all my servers/ instances/ databases and …

  hb21l6

  5 replies

  12 years ago

  By: SQLRNNR

• Accidental creation of certificate and symmetric key on master database.

  I meant to setup a certificate and symmetric key for a specific database on one of my servers. I a…

  bkrankel

  1 replies

  12 years ago

  By: SQLBlimp

• Parsing out a string field

  Hi, I need help parsing out a field, but I am not sure how to extract just the specific part that I…

  skaggs.andrew

  11 replies

  12 years ago

  By: paul.e.ray

• replication

  I need to Deny insert,update,delete on object::schema_name.replicatedobjectname to Login, how to g…

  ramyours2003

  3 replies

  12 years ago

  By: MyDoggieJessie

• list of tables

  I need a query that lists all the tables in all the databases which consumes more space , i need…

  ramyours2003

  3 replies

  12 years ago

  By: SQLRNNR

• outragous query duration during load

  Hi, I'm performing a load test on my SQL server. I start a load of one main stored procedure in our…

  aviadavi

  10 replies

  12 years ago

  By: Jeff Moden