Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
2009-06-22 (first published: 2009-06-08)
1,043 reads
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
2009-06-23 (first published: 2009-06-08)
1,183 reads
Records snapshots of space usage stats by partition, index, table, schema, filegroup, and database. Stats include Reserved, Used, and Data for row, lob, and overflow.
2009-06-15 (first published: 2009-05-30)
1,235 reads
Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.
2013-07-17 (first published: 2009-05-30)
2,749 reads
This is not what the poster is asking for. They are requesting that in the same query, return both scalar and non-scalar aggregates, ie count of all and also count of a single group, and given the format the poster wanted (repeating the scalar aggregate in each row), none of the solutions presented so far […]
2003-06-19
You need to use a CASE statment instead of WHERE clause to restrict the values going into the aggregate. The code below assumes that you can't have negative values in dbo.Defect_Data.SUMDEFECTS. So you don't need to restrict the input to the SUM. If you did, you would use a CASE statement as with QDefectCount, but […]
2003-06-19
1 reads
You need to use a CASE statment instead of WHERE clause to restrict the values going into the aggregate. The code below assumes that you can't have negative values in dbo.Defect_Data.SUMDEFECTS. So you don't need to restrict the input to the SUM. If you did, you would use a CASE statement as with QDefectCount, but […]
2003-06-19
🙁 The problem is that I am also trying to get the total questionnaires per WSI not just the one that have SUMDEFECTS > 0. I need to have it as one so I can then build the html table with the summary information.
2003-06-18
1 reads
Hi eletuw, I get this running when I remove the LOCAL FAST FORWARD option. Hm, now I only need to figure out, what this is doing? Cheers, Frank
2003-06-18
I made the chnages but still got the error. I am psoting the entire query in cae it might help. ========================================== DECLARE @ID INT DECLARE @Name varchar(200) DECLARE @Text nVarchar(2000) DECLARE @cDate datetime DECLARE @ColID int DECLARE @Type varchar(10) -- Declare the cursor DECLARE CURSOR_OBJ CURSOR LOCAL FAST_FORWARD FOR SELECT TOP 100 PERCENT dbo.sysobjects.id, dbo.sysobjects.name, […]
2003-06-18
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers