Cloud Computing Basics - Achieving High Availability
Learn about high availability in the cloud at a conceptual level.
2022-03-28
112 reads
availability groups
Cloud Computing Basics - Achieving High Availability
Learn about high availability in the cloud at a conceptual level.
2022-03-28
1,214 reads
Can deleting rows make a table…bigger?
Michael J. Swart posted an interesting question: he had a large table with 7.5 billion rows and 5 indexes. When he deleted 10 million rows, he noticed that the indexes were getting larger, not smaller.
2019-03-22
2,752 reads
Have Availability Groups Gotten Easier Lately?
2018 is coming to an end, and AGs have been out for 6 years. They're stable now, right?
2018-12-28
2,749 reads
Automatically Failover (Enable or Disable) Jobs Based on HADR Role
If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.
2018-11-14 (first published: 2018-11-12)
2,779 reads
RE: help with date parameters
This is the result set it presented and I don't understand.... I am running a summary on activity for the year...my columns being the different activities and the months - the timeframe I'm not sure what this is....1 D June 1 D August 6 D November 30 D December 2 P June 32 P July 1 PK June 1 PK July 2 PK August 3 PK November 3 PK December 2 U […]
2005-05-25
RE: Connect to different servers thru stored procedure
Short answer (based on complexity) you can't. Why not use tried and true methods such as OSQL i.e (inside a BAT file)SET ChangeRecord=ABC123 SET LOGDIR="C:\Temp\%ChangeRecord%" IF NOT EXIST %LOGDIR% MKDIR %LOGDIR% SET LOG=%LOGDIR%\ProdInstall_%ChangeRecord%_runsql.log SET PREFIX=%LOGDIR%\prd. SET SRVNAME=YourServerNameHere SET DB=YourDBNameHere ECHO. > %LOG%osql -S%SRVNAME% -E -n -d%DB% -i "C:\Temp\PROD\Database\Stored Procedures\SPNAMEHERE.sql" -o %PREFIX%SPNAMEHERE.sql.err >> %LOG% OR a […]
2005-05-24
RE: SQLServer 2000 Memory usage
Couldnt have put it better myself (but thats probably the wines fault )
2005-05-11
RE: what does DBCC stand for?
Just a thought, but it struck me that the difference between Consistency Check and Concole Command could possibly be significant in a certification exam. I would really hate to miss a question on something so trivial.Myself, it'll always be the former, I harken back to the 4.21a days on top of LanMan/OS2.
2005-05-05
Blogs
So You Want to Deploy Power BI Project files (PBIPs)?
By Angela-Henry
Have you heard the news about the new Power BI Project files? Okay, maybe...
DBAs, Organizing Your SQL Scripts in Git
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
Only Capture Extended Events For a Given Time
It’s a great question. Let’s say you want to capture stored procedure completions. But,...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers