SQL RNNR
1 DBA's Professional Blog
Blogroll
- Aaron Bertrand
- Aaron Nelson
- Adam Machanic
- Alex Kuznetsov
- Andy Warren
- Brad McGehee
- Brad Schulz
- Brent Ozar
- Buck Woody
- Christophe Laporte
- Dave Ballantyne
- David Barbarin
- Dukagjin Maloku
- Ewald Cress
- Gail Shaw
- Gianluca Sartori
- Grant Fritchey
- Hugo Kornelis
- Jack Corbett
- Jeremiah Peschka
- Jimmy May
- Jorge Segarra (SQLChicken)
- Josef Richberg
- Kalen Delaney
- Kendal Van Dyke
- Kimberly Tripp
- Linchi Shea
- Lynn Pettis
- Michelle Ufford
- Paul Randal
- Paul White
- Phil Factor
- SQL Server Protocols
- Steve Jones SSC
- Thomas LaRock
- Tim and Lori Edwards
- Tim Ford
- TSQL Challenges
Categories
- Blogging (9)
- Book Reviews (33)
- Certification (5)
- Corner (39)
- DatabaseMasters Syndication (2)
- Extended Events (114)
- Meme Monday (7)
- Meme15 (2)
- News (644)
- Presentations (10)
- Professional (633)
- Running (11)
- Scripts (74)
- Security (9)
- SQLBP (4)
- SQLServerPedia Syndication (301)
- SSC (534)
- SSG Syndication (4)
- SSSOLV (62)
- The Corner dep (58)
- TSQL Tuesday (77)
- Uncategorized (1)
-
Popular Posts
- T-SQL Tuesday #38 – Standing Firm (30)
-
T-SQL Tuesday #051: Place Your Bets (28)
- T-SQL Tuesday #009: Beach Time (22)
- 12 Days of Christmas 2013 Day 1 (21)
- MCM Road Less Traveled (14)
-
Learning Extended Events in 60 Days (14)
- Last Time CheckDB was Run (13)
-
Audit who Dropped the Database (13)
- Having Cake and Eating it too (13)
- Last Known Good CheckDB (12)
SQLHelp
- @AliRazeghi: @NedOtter @SQLSoldier @NedOtter #SQLHelp would you know by what mechanism the tnx is written to the log on the prin… https://t.co/BLSUR4JNuT
- @NedOtter: @AliRazeghi From the epic tome "Pro SQL Server 2008 Mirroring", written by our beloved @SQLSoldier : txn written t… https://t.co/Wqds6GGaHw
- @AliRazeghi: #SQLHelp docs say it works 'on the physical record on the log level' but I'm not sure by what mechanism it uses to send that data over.
- @AliRazeghi: #SQLHelp Need help figuring out how mirroring sends transaction data to the mirrored node. Log Shipping restores l… https://t.co/0lYDcX71E8
- @SeekWell_io: RT @Kevin3NF: #sqlhelp I've never tried this before... SQL Service is stopped, as is the Agent. Starting the agent then auto starts the…
- @shadyrudy: @sqlstudent144 When I've done this, I used a "real" table: create table tempdb.dbo.taco (someid int identity (1,-1)… https://t.co/Us9gCgpf7D
- @sqlstudent144: Just to confirm something, this doesn't work and has never worked correct? SELECT * FROM <linkedserver>.tempdb.dbo… https://t.co/m0Jr8QLrT6
- @AngryPets: @oriordanrichar1 You can query https://t.co/gavuNW55U2_exec_procedure_stats : https://t.co/BoTtH5ihje There are… https://t.co/wOxuszma8Q
- @oriordanrichar1: #SQLHelp Any idea how to get runtime statistics per stored procedure as opposed to query from Query Store?
- @k_t_schmidt: #sqlhelp Reporting ?: When you have users that want to see all the data or some of the data, what are good standar… https://t.co/zSv0RE8psn
© 2019 SQL RNNR All rights reserved
- Mobile View
Fastfood theme by TwoBeers Crew - Powered by WordPress