Forum Replies Created

Viewing 15 posts - 6,796 through 6,810 (of 49,552 total)

  • RE: Row index and Row number

    That one is unique, because it's a PRIMARY KEY. It's the PRIMARY KEY which forces the column to be unique, not the identity. Identity just provides incrementing values.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2015 at 2:12 am

    #1770043

  • RE: "Best Practices" Questions

    syquil (1/7/2015)

    1 - Only execute queries against production on production. "Connecting through SSMS from your dev box and running queries and schema updates can bring down the server"

    We have...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2015 at 1:28 am

    #1770031

  • RE: DBCC CHECKDB on a very big database.

    Since CheckDB generates a snapshot and runs against that shapshot by default, manually generating a snapshot's not going to achieve very much.

    Physical_Only means a lot of checks are skipped. While...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2015 at 1:23 am

    #1770030

  • RE: Migrating from SQL 2000 to SQL 2008 R2

    Not offhand, but a quick google search for articles on setting up log shipping should return a few hundred results.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2015 at 1:18 am

    #1770029

  • RE: Row index and Row number

    hazeenahazu (1/13/2015)

    I got some idea about row number and row Id as :

    row id is the unique index number of every row of table maintaining by database automatically...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2015 at 1:14 am

    #1770027

  • RE: get table size and row count

    The views you want are sys.partitions or sys.dm_db_partiton_stats.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2015 at 1:09 am

    #1770026

  • RE: TempDb - Split or Add

    You could call the files .txt and it would work the same. SQL doesn't care in the slightest what the extensions of its data files are.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2015 at 7:31 am

    #1769813

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

    To be honest, there's so much wrong that forums aren't going to be much help. You should probably see if you can find someone in your area that's willing to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2015 at 5:34 am

    #1769771

  • RE: Row index and Row number

    Well, they are. In the sense that Row Number exists and Row Index doesn't.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2015 at 5:24 am

    #1769767

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

    Maybe ask this on an MS Access forum, since this is quite obviously not SQL Server.

    You also have several security flaws with this code. Passwords stored in plain text been...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2015 at 4:32 am

    #1769751

  • RE: Database transfer question

    Backup the entire DB (you can't back up specific tables), restore and drop the ones you don't need.

    10 million rows isn't that large.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2015 at 3:18 am

    #1769735

  • RE: Is there ANY scenario where SA can be denied rights to specific objects?

    Erland Sommarskog (1/12/2015)

    As I understand it, membership in sysadmin means that all permissions checks are waived.

    Correct.

    Any login that's a member of the sysadmin fixed server role bypasses ALL security checks....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2015 at 1:51 am

    #1769727

  • RE: Migrating from SQL 2000 to SQL 2008 R2

    Log shipping will work, you just have to have the destination DB RESTORING, standby isn't an option when there's a version mis-match.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2015 at 1:46 am

    #1769726

  • RE: Best way to migrate data from 2005 to 2008R2 env

    Script all their modified procs, views, functions out. Backup, restore with overwrite. Run script with all objects (take a backup of their DB first, just in case)

    Likely to be faster...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2015 at 1:44 am

    #1769725

  • RE: difference between Len() and DataLength()

    Please note: 8 year old thread

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2015 at 1:43 am

    #1769723

Viewing 15 posts - 6,796 through 6,810 (of 49,552 total)