Viewing 15 posts - 3,736 through 3,750 (of 49,552 total)
You can't. @@Rowcount is always the number of rows affected by the previous statement. DROP TABLE affects no rows, so sets @@rowcount to 0.
You could use an output variable 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
January 28, 2016 at 1:18 pm
Alan.B (1/28/2016)
What I hate about Azure SQL & Azure SQL Data Warehouse is the limitations, specifically the T-SQL limitations.
Which ones?
I ask because, for the Azure SQLDB side, most of...
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
January 28, 2016 at 12:36 pm
Welsh Corgi (1/28/2016)
GilaMonster (1/28/2016)
BrainDonor (1/28/2016)
I would never have thought of that use for it - I've always associated it purely with disaster recovery.
There are two different things called the 'tail...
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
January 28, 2016 at 11:46 am
There is no such thing as an unlogged operation in SQL. Every change to data, objects or the database itself is logged.
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
January 28, 2016 at 11:46 am
There's nothing wrong with a production server on a VM. I have very few clients still using bare metal servers. Configured correctly, VMs are fine. Badly configured, VMs can be...
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
January 28, 2016 at 9:12 am
Probably not.
Unless they have:
- Done sufficient analysis to determine that the workload is IO-bound
- Are planning to put the additional data files onto a separate physical IO path/device
- Have carefully...
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
January 28, 2016 at 8:20 am
BrainDonor (1/28/2016)
I would never have thought of that use for it - I've always associated it purely with disaster recovery.
There are two different things called the 'tail log backup'.
1)...
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
January 28, 2016 at 7:42 am
Yes, it makes the database unavailable when you use it. You would have needed to run a RESTORE, not another backup to get the DB usable again.
You use it when...
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
January 28, 2016 at 7:37 am
dough-378918 (1/28/2016)
From a backup/restore perspective then, especially to try to restore a portion of a system to a certain point-in-time, is thereany reason to use Filegroups?
No. If you're required 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
January 28, 2016 at 7:05 am
What does SELECT @@version return? (the whole thing)?
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
January 28, 2016 at 6:02 am
Personally I prefer new VM with an instance over a second instance on the same machine. Instancing gives partial resource separation (memory) and partial security separation, VMs give a lot...
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
January 28, 2016 at 5:17 am
dough-378918 (1/27/2016)
I'd just like to confirmthat it's not possible to restore a particular filegroup to point-in-time than the other
filegroups may be.
Correct, it's not possible.
When any part of the...
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
January 28, 2016 at 2:01 am
Hugo Kornelis (1/27/2016)
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
January 27, 2016 at 5:08 am
ChrisM@Work (1/27/2016)
GilaMonster (1/27/2016)
ChrisM@Work (1/27/2016)
Two databases on the same "instance" isn't allowed or the two databases can't reference each other using three-part naming?
With Azure SQL DB, there's no such thing...
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
January 27, 2016 at 3:23 am
The ascending key problem: http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/
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
January 27, 2016 at 2:53 am
Viewing 15 posts - 3,736 through 3,750 (of 49,552 total)