Viewing 15 posts - 1,216 through 1,230 (of 59,066 total)
I had to laugh, in painful sympathy, at that last sentence, Grant.
Ha!
And we can keep going. Don't let Jeff get started on fragmentation. Don't let me get started...
August 13, 2023 at 6:00 am
Just to ask the question, the servers aren't set to automatically shut down for a part of the day, are they?
If not, you might want to make a call to...
August 13, 2023 at 5:52 am
To use out-of-row for LOBs:
EXEC sp_tableoption 'SchemaName.TableName', 'large value types out of row', 1;
That won't move existing LOBs. You have to update each row to get...
August 13, 2023 at 5:41 am
Check to see if forced parameterization is on. If it is, first take a baseline to see what performance is on the box then turn it off and check again. ...
August 13, 2023 at 5:37 am
We do nightly restores of two of our primary databases.
The large one is a 2TB database and has an 80GB log file with a compressed backup size of 500GB.
The smaller...
August 13, 2023 at 5:31 am
The key to my learning in SQL is that I learned very early on that one good test is worth a thousand expert opinions and taught myself how to make...
August 12, 2023 at 4:09 am
Not enough info to help here. Are you sure that you created the file group on the correct disk drive?
August 10, 2023 at 11:46 pm
Thank you everyone. It turned out to be a network issue.
What was the network issue???
August 10, 2023 at 11:40 pm
Using the sample data that you've so nicely provided, can you post what the required output is?
August 9, 2023 at 11:09 pm
Quick and simple. Converting a column from NVAR(MAX) to VAR(MAX) has drastically increased the data stored in the column.
Table size in MB is drastically higher after the conversion. There...
August 9, 2023 at 2:49 pm
I find it interesting that this doesn't work when using the correct zero date for a datetime2:
DATEADD(dd,DATEDIFF(dd,'1900',DateValue),CONVERT(DATETIME2,TimeValue)) ...
August 9, 2023 at 2:31 pm
None of those answers coming up on g0ogle are relevant to my question. They either talk about tracking down link servers which is not my issue, or they talk...
August 8, 2023 at 8:50 pm
Given that the data type is DATETIME2(7), we can assert the following: The DATE data type is 3 Bytes big-endian, the TIME(7) is 6 Bytes...
August 8, 2023 at 12:54 am
Given that the data type is DATETIME2(7), we can assert the following: The DATE data type is 3 Bytes big-endian, the TIME(7) is 6 Bytes big-endian and...
August 7, 2023 at 11:04 pm
We use the following providers for linked servers and use OPENQUERY, which proved much faster than OPENROWSET (with the disclaimer that check was made years ago). This allows the query...
August 7, 2023 at 9:10 pm
Viewing 15 posts - 1,216 through 1,230 (of 59,066 total)