Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server
Search options not deleted
user 141150
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
0
votes
How to diagnose MSSQL high CPU spike
When you see 100% you are seeing a snapshot from Os Perspective: It takes a sample of process total CPU, waits for 1 second(default), takes another sample, and shows you this diff (and some tools can …
- 99
1
vote
How to make drive with SQL Server files and databases smaller when you can't easily resize d...
It works. I've already done this in production environments.
If it is not a boot partition, it is easier.
Remember to do the CHECKDB after all and guarantee that permissions are equal to the ones on t …
- 99
0
votes
“Cannot continue the execution because the session is in the kill state” Error?
This is a crash dump. "ACCESS VIOLATION" indicates in some moment of code execution (NOT T-SQL code, but SQL C++ source code) some of its threads try to access an invalid memory address
Normally, thi …
- 99
0
votes
CDC - I cannot disable that on the second instance
Check which permissions that user has granted and remove them:
select * from sys.database_permissions
where grantor_principal_id = user_id ('cdc');
The error saya that cdc user ran grant or dey statem …
- 99
0
votes
MSSQL - SELECT on data from JOIN reference
Use Outer apply:
SELECT
...
,CE.*
FROM
...
OUTER APPLY (
SELECT
Color = max(case when key = 'color' then value else '' end)
,flavor = max(case when key = 'flavor' then value else '' end)
FROM
Custom …
- 99
-1
votes
How do I identify the source of the 17886 errors ("server will drop the connection") in my S...
Try to use
select * from sys.dm_os_ring_buffers
to get more details about source clients.
Try filter type RING_BUFFER_CONNECTIVITY.
- 99
1
vote
Accepted
Extended Events - How to capture executions for a given stored procedure along with the pass...
This is possible only if your proc is the oproc submitted in batch. If this is case, use rpc_completed or sql_batch_completed and filter with like predicate
Nested procs is notnpossible see parameters …
- 99
2
votes
Accepted
What causes DBCC CHECKTABLE to return "session is in the kill state"?
Many things cause a session to enter a kill state.
If other user kills your session, or if running command throws an error which severity needs terminate the connection (check this for more info https …
- 99