Viewing 15 posts - 6,706 through 6,720 (of 49,552 total)
cherrygalaxy (1/23/2015)
It seems like a slam dunk to combine the indexes into one with all the included columns together.Am I correct?
Absolutely correct
P.S. - My guess is that this...
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
January 26, 2015 at 1:24 am
Split the sentence into words, store each word in a new row. Then you can use INTERSECT and EXCEPT to get the results you want.
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
January 26, 2015 at 1:23 am
Backups do not run through the buffer pool. They use memory outside of that. Look up 'Backup Buffers' for more details
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
January 23, 2015 at 8:46 am
Other question is why?
Generally for backups you want the storage as simple as possible so that retrieving the files for a restore is as easy as it can be made....
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
January 23, 2015 at 8:45 am
Why do you think something's missing? Is it giving an error? Not working? Something else?
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
January 23, 2015 at 8:43 am
SQL 2008 R2 is a different version, so you'd start by buying new licenses for the new version. It's not a service pack.
Though to be honest, given that SQL 2008...
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
January 23, 2015 at 7:47 am
The size will be the problem. The file type isn't, SQL doesn't care at all what goes into a varbinary(max), it's just binary data as far as the database engine...
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
January 23, 2015 at 7:29 am
Yes, you can, because as I said above, "If you specify the port number, the lookup to SQL Browser isn't necessary and the client connects to the server and port...
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
January 23, 2015 at 7:25 am
All a named instance is is a 'lookup' to a port number, kinda like the friendly name that resolves to an IP address. What happens when you connect to a...
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
January 23, 2015 at 6:50 am
Or, if you want to be even more confusing...
create table [where]
([where] char(5),
[from [where] varchar(25),
[select [where from [where] varCHAR(50),
)
go
insert into [where] values ('from where', '[from [where]]', 'select [where]...
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
January 23, 2015 at 3:26 am
So a query that runs once an hour and takes 1001 ms is a bad query, but one that runs 50 times a minute and takes 900 ms is a...
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
January 23, 2015 at 2:22 am
sm_iransoftware (1/22/2015)
- I only check the queries with duration greater than 1000 ms. now.
Why?
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
January 23, 2015 at 1:38 am
Luis Cazares (1/22/2015)
Brandie Tarvin (1/22/2015)
rodjkidd (1/22/2015)
Steve Jones - SSC Editor (1/21/2015)
What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for 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
January 23, 2015 at 1:32 am
It's possible to have deadlocks with partition escalation that you wouldn't otherwise be able to get. There's a brief discussion in https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
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
January 23, 2015 at 1:29 am
Couple comments immediately
Why the dynamic SQL? All you're doing there is making things more complex, there's nothing in that query I can see that requires dynamic SQL.
SELECT oc.[name] AS...
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
January 23, 2015 at 1:28 am
Viewing 15 posts - 6,706 through 6,720 (of 49,552 total)