Viewing 15 posts - 121 through 135 (of 1,838 total)
Does anyone actually like the "3 hitter rule"? I can't imagine it will affect the game length much, but it seems like it can have serious implications for rosters. Given...
February 13, 2020 at 7:34 pm
It looks like John's script only handles server level permissions, I think you'd need something like this to copy the database level permissions and roles for these users:
February 12, 2020 at 10:03 pm
what I am trying to do is read one row of data, and if there is a constraint, i.e TERMS_DC and that value of NET 0 isn't on the...
February 12, 2020 at 9:24 pm
...
1. Table NEXT_FIELD_KEY hold the "field name" and next running key (12 digit numeric running number) of every other table in our database. Any table's primary key (PK) (running...
February 12, 2020 at 8:45 pm
Maybe I'm looking at it the wrong way, but if there is 161 GB of space free within the database, why does it need to grow more? What is the...
February 11, 2020 at 10:09 pm
Is the SSMS installation location in your system path? What version of Windows are you using? It might be easier to put a shortcut in your Start menu somewhere.
February 11, 2020 at 8:40 pm
Ha, I was going to say 3 too, same rationale as anthony.green. Then I saw Grant Fritchey was the author, and I've read enough of his recent posts to...
February 11, 2020 at 7:24 pm
If you are sure your LDAP connection string is right, could it be possible you are hitting the 1000 row limit for a resultset? That same error is used when...
February 10, 2020 at 9:03 pm
I have a similar view of certifications. I've found that they are neither necessary nor sufficient to prove someone's proficiency in understanding a topic. Don't get me wrong, it is...
February 10, 2020 at 8:46 pm
Sorry for not getting back to this sooner, yes the disks are a resource of the SQL Server role. I'm still trying to decipher your environment and setup though. If...
February 5, 2020 at 9:55 pm
If you are on 2016 or newer, could you use the built in QueryStore feature instead of trying to build your own query store?
February 5, 2020 at 8:44 pm
If you are not sure what is causing the transaction log file to grow, you can find a recent history of this using data collected by the default trace, which...
February 5, 2020 at 8:33 pm
If you are trying to get subtotal lines in your results could GROUPING SETS help?
February 5, 2020 at 7:47 pm
Is this RAM usage spike after 3 days expected considering I already set the max server memory to 24Gb? I thought setting the max limit no longer allow SQL to...
February 5, 2020 at 7:32 pm
The problem with trying to query Active Directory using a query running in Management Studio is your credentials have to be passed from your computer, to the SQL Server, and...
February 4, 2020 at 9:24 pm
Viewing 15 posts - 121 through 135 (of 1,838 total)