Viewing 15 posts - 136 through 150 (of 1,987 total)
Single user for clustered instances: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/start-sql-server-in-single-user-mode?view=sql-server-ver16
February 10, 2023 at 9:56 am
February 3, 2023 at 10:06 am
Celko, why did you choose CHAR(10) whilst an int works perfectly? Certainly in the age of anomized data
I didn't get the course "Since an identifier has to be on a...
February 2, 2023 at 10:58 am
Thanks for posting your solution
February 1, 2023 at 11:42 am
Thanks for mentioning it, wasn't aware of this kind of database
February 1, 2023 at 11:42 am
It's possible, done it a few times after testing. (without replication / availability groups ...). Can't remember needing old installation media
January 30, 2023 at 3:12 pm
Check
It will switch to readonly when the storage limit is reached. It will a bit of system overhead but not much. Currently one of the best ways to identify...
January 30, 2023 at 10:57 am
If your tables don't have a clustered index (aka heap-table), the space might not be released rightaway
https://www.sqlskills.com/blogs/paul/sqlskills-sql101-why-does-my-heap-have-a-bunch-of-empty-pages/
January 30, 2023 at 10:47 am
For efficient filtering it should be the first column of an index. (so there are statistics about time distribution). As Thom A mentioned, the clustered index won't help much for...
January 20, 2023 at 10:41 am
Before changing the clustered index, you should know what other queries are impacted and their importance
Is a non-clustered index on [Time] an option?
Is [Time] a string datatype? Since you compare...
January 20, 2023 at 10:25 am
If the program is multiple connections and still only uses one core (12%) it could also be due locking or the way it is programmed.
Consider contacting the vendor about the...
January 19, 2023 at 10:49 am
That's bad. The script seanachim script posted is viable.
From SQL Server Configuration manager:
The server is up and running?
TCP is enabled? (might be disabled)
January 18, 2023 at 2:20 pm
I agree with Jeff, the applications seems to use a single connection sequentially.
Also, there seem to be a lot of databases on the C-drive which is usually reserved for OS....
January 18, 2023 at 8:55 am
Strange that you would need to modify the clients firewall for outgoing traffic
Does the SQL Server use TCP fixed ports or dynamic?
January 17, 2023 at 4:46 pm
About limited to 12%. Looks like single-core processing. SQL Server is pretty good at detecting available cores.
MaxDop accidentally set to 1 at server/database/query level ?
VM limited to 12% : are...
January 16, 2023 at 10:13 am
Viewing 15 posts - 136 through 150 (of 1,987 total)