New answers tagged sql-server-2012
0
votes
Difference between logical and physical reads/writes
As a DBA's stand point we don't need to worry about logical read; it's our most desired thing. While physical read is where we can have the most PTO.
Logical read is getting a data from Cache or ...
1
vote
Insert 2 output result sets from sp_spaceused into Temp Table (SQL Server non-2016)
A trick to inserting two result sets into one table? No. I do not believe that is possible.
However, what I've done in the past, as I'm sure you have experimented with, is modify the code inside the ...
- 301
-1
votes
Insert 2 output result sets from sp_spaceused into Temp Table (SQL Server non-2016)
CREATE TABLE #DatabaseSizes_4
(
database_name NVARCHAR(128),
database_size VARCHAR(18),
unallocated_space VARCHAR(18),
reserved VARCHAR(18),
data VARCHAR(18),
index_size ...
0
votes
Get Point from Another Table based on Category and Value Range
CROSS APPLY a PIVOT table -
MSDN Documentation here - https://learn.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver16
I populated your data using this code -
...
- 301
Top 50 recent answers are included