Viewing 15 posts - 4,396 through 4,410 (of 49,571 total)
ScottPletcher (10/30/2015)
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...
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...
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...
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
...
October 29, 2015 at 4:57 pm
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...
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...
October 29, 2015 at 8:12 am
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...
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
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...
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...
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,...
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....
October 27, 2015 at 11:35 am
Viewing 15 posts - 4,396 through 4,410 (of 49,571 total)