Short answer: yes. Full database backups and differential database backups do NOT break the transaction log chain.

Also, if your crash did not destroy the transaction log and you can...

Being an Availability Group, you can also take backups from the replicas. Transaction log backups should still come from the primary replica, as this is the only way to clear...

If you know when the backups are kicked off, then you know when to look and see what application/host is running the BACKUP DATABASE command. Look with Activity Monitor or...

Define 'high load', and your need to load balance. Individual SQL Servers can handle billions of batches per day. Storage is usually the bigger bottleneck.

Sharding your data allows you...

A quick check of the function's source :

USE master;

GO

EXEC sp_helptext 'fn_varbintohexstr';

GO

Reveals the source code:

create function sys.fn_varbintohexstr

(

@pbinin varbinary(max)

)

returns nvarchar(max)

as

begin

return sys.fn_varbintohexsubstring(1,@pbinin,1,0)

end

OK, that...

A terrific blog for reading the details found in sys.dm_os_ring_buffers (including the query you seek) may be found here:

https://bwunder.wordpress.com/2012/07/29/monitoring-and-troubleshooting-with-sys-dm_os_ring_buffers/

-Eddie

Offhand, I'd suggest trying a DDL trigger on the CREATE DATABASE event (note that attaching fires 'CREATE DATABASE ... FOR ATTACH'), and see if that catches it.

If so, you can...

To get the list of database files in the backup (you will need to provide a new physical location for each file using the MOVE TO clause):

RESTORE FILELISTONLY...

...the impact on the log file, possible fragmentation, etc. The tables themselves are small (typically 2-5 columns and anywhere from 5 - 100 records each) and we would be...

drew.allen (7/22/2015)

---

It sounds like you want to use the DENSE_RANK() function.

;

WITH table_ranked AS (

SELECT iINDEX, PARENTID, DOCUMENTID, QTY, REVNR, XREFID

,DENSE_RANK() OVER(PARTITION BY PARENTID ORDER BY REVNR DESC) AS dr

FROM #TableA0

)

SELECT...

Are you using T-SQL commands that were new in SQL 2005, such as PIVOT, CTEs, ROW_NUMBER(), RANK_(), TILE()?

Later versions of SQL Server allow you to use new T-SQL even though...

PIVOT will produce your results, provided that you are willing to specify the type names when you write the query:

SELECT [Supplier Name], Onions, Potatos, Chocolate

FROM

(SELECT s.nam AS [Supplier...

You can use literal values and variables much the same way you reference columns in a SELECT statement, and you may mix them.

This shows adding a literal Domain value to...

Try this instead:

SELECT DISTINCT SalesAccountNumber

FROM Sales.SalesOrderHeader

WHERE SalesEndDate!='30/12/3049'

It's the same query with a lot less work.

How are you licensing SQL Server?

If you want to (legally) download anything but freeware/trialware, then you'll need access an account with Microsoft that includes download rights, such as an...