SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Restoring over an offline database

  Good Morning Experts, Can I restore over a DB that is in an offline state (using WITH REPLACE)?

  coolchaitu

  2 replies

  6 years, 4 months ago

  By: Grant Fritchey

• logical architecture and physical architecture of data files(.mdf)

  Good Morning Experts, Could you please let me know the logical architecture and physical architectu…

  coolchaitu

  2 replies

  6 years, 4 months ago

  By: Jeff Moden

• How does the query optimizer gets the statistics information

  Good Morning Experts, How does the query optimizer(in the relational engine) gets the statistics in…

  coolchaitu

  2 replies

  6 years, 4 months ago

  By: Jeff Moden

• Deleting records from very large table and users experiencing slowness and low performance

  Good Morning Experts,There is a very large table having 8 million records and I am deleting 6 milli…

  coolchaitu

  2 replies

  6 years, 4 months ago

  By: Lynn Pettis

• A "safe" replacement for xp_CmdShell - for test purposes

  Hi, I'm currently reverse-engineering a system which makes use of xp_cmdshell to move files around …

  glen205

  7 replies

  6 years, 4 months ago

  By: glen205

• sp_who2 permissions

  Good Morning Experts,A user wants to be able to run sp_who2 and submitted an approved ticket . I ga…

  coolchaitu

  1 replies

  6 years, 4 months ago

  By: Thom A

• Unused space; shrink or not shrink

  Hi,I have some experience with the SQL Server databases but I'm not trained as one..., so mayb…

  rpeters76

  8 replies

  6 years, 4 months ago

  By: Jeff Moden

• How to get a record if any of it's column values is set to true ?

  I have a table which has 20 or so boolean True/false. How do I find a record in the table which has…

  judejay26

  11 replies

  6 years, 4 months ago

  By: Jeff Moden

• Inserting multiple rows of data in single temp table

  Hello, I have this basic script. I get the following error when trying to insert values:Msg 156, Le…

  VegasL

  5 replies

  6 years, 4 months ago

  By: drew.allen

• Eliminate Null Values in a Cross Tab Query

  Hi there, I have a problem with eliminating null-values in a cross tab. Perhaps someone out there w…

  r_slot

  9 replies

  6 years, 5 months ago

  By: r_slot

• log file of primary replica database in AG is full

  Good Morning Experts, The log file of primary replica database in AG is full and it cannot be shrun…

  coolchaitu

  4 replies

  6 years, 5 months ago

  By: ManicStar

• Difference between Snapshot Isolation Level and Read Committed Snapshot Isolation Level.

  Good Morning Experts, I am not understanding the difference between Snapshot Isolation Level and Re…

  coolchaitu

  1 replies

  6 years, 5 months ago

  By: BrainDonor

• How would I go about this ...checking if data exists in a table

  So I am working within a stored procedure that is loading data into a blank table from table 1. The…

  gothaimviii

  7 replies

  6 years, 5 months ago

  By: Jeff Moden

• Inner query returns more than one row

  Hi folks, I have a problem that I don't know how to solve: the subquery returns more than one row. …

  Data Cruncher

  4 replies

  6 years, 5 months ago

  By: Data Cruncher

• Added data file of user database to wrong drive

  Good Morning Experts, As per our DBA guidelines, tempdb data files are stored in G drive, and user …

  coolchaitu

  6 replies

  6 years, 6 months ago

  By: Eirikur Eiriksson