Viewing 15 posts - 4,396 through 4,410 (of 49,552 total)
ScottPletcher (10/30/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 30, 2015 at 12:16 pm
ben.brugman (10/30/2015)
For example F, H, D in the where clause.
This results in a reasonable fast search with a full...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 30, 2015 at 12:06 pm
ben.brugman (10/30/2015)
The Question was:Can SQL-server use an index and then use the covering index to collect the data?
(And therefore not using the 'main' table).
The answer is No.
What you'll see will...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 30, 2015 at 12:02 pm
Admingod (10/29/2015)
I am running on 2008 SQL Server enterprise. Below is what i am gettingMsg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.
You've...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2015 at 5:16 pm
Worked fine in my test. Maybe I'm using a different version. What does this return on your instance?
CREATE TABLE #Temp (
AVarcharColumn VARCHAR(20)
)
INSERT INTO #Temp
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2015 at 4:57 pm
You're very welcome. 🙂
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2015 at 11:56 am
marcolorado (10/29/2015)
SQL will never give a repeated spid number for two different connections at same time, correct?
Correct, just be careful, the SPID can be reused very quickly after a session...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2015 at 11:39 am
No. Lookups are always to the clustered index.
That will either use the index on F and do key lookups to the cluster or will scan the covering index if the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2015 at 8:12 am
.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2015 at 10:16 pm
It is not unique.
It's not the session id from sysprocesses. It's the process ID (windows process ID) that the client application has on the client machine.
Go to a client, open...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2015 at 12:26 pm
I strongly do not recommend moving master from one instance to a different one.
Script out your logins (sp_helprevlogin), your linked servers, your config settings, etc
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2015 at 11:43 am
happygeek (10/28/2015)
"I/O is frozen on database xxxxxxx. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup"
That's not an error.
3rd party backup tools...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2015 at 11:42 am
Michael L John (10/27/2015)
Secondly, from the logs, it appears that the service account 'DGI\SPSQLSvc' cannot log into the server.
That's the sharepoint service account by all appearances (trying to connect...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2015 at 10:29 pm
There's something seriously wrong, it just looks from the error log that SQL's the victim, not the cause. All the login failures are because SQL can't open the various databases,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2015 at 10:27 pm
Don't look at the costs. Those are estimates, and they have to add to 100%. Knowing that something is 33% or 25% is useless, it says nothing of any value....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2015 at 11:35 am
Viewing 15 posts - 4,396 through 4,410 (of 49,552 total)