Viewing 15 posts - 6,211 through 6,225 (of 49,552 total)
RonKyle (4/10/2015)
SELECT ROLE_ID
WHERE PERSON_ID = ?
while the second is more suited to
SELECT *
WHERE PERSON_ID = ? AND ROLE_ID =...
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
April 10, 2015 at 8:17 am
maurer.martina (4/10/2015)
But maybe there is a TSQL-Nerd out there? Sometimes, wonder happens...
I tried once to write a parser for MS Access SQL. After 3 months (and I was doing it...
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
April 10, 2015 at 8:14 am
Neither index is particularly useful for a query that filters only on RoleID, see the blog post I posted.
Again, without looking at the queries that run against a table,...
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
April 10, 2015 at 8:08 am
Depends on the queries being run against that table, impossible to answer without knowing the queries.
This may give some insight into indexes and queries
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
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
April 10, 2015 at 7:57 am
Yes, they need to be restored as the last step in the restore process.
Another option is to make the archive filegroup readonly before you take the backup, but then you...
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
April 10, 2015 at 7:20 am
Eirikur Eiriksson (4/10/2015)
GilaMonster (4/10/2015)
I love finding out that I'm giving a training course from the newsletter sent out the the entire company.
Especially when it's pushed forward to the day of...
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
April 10, 2015 at 7:16 am
maurer.martina (4/10/2015)
allowed characters between "delete" and "from" and "myTable" are only blanks, right?
No. To start with, the FROM is optional
Valid (but that your replace won't pick up)
DELETE[MyTable];
DELETE
FROM
[MyTable];
And one it...
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
April 10, 2015 at 7:07 am
I love finding out that I'm giving a training course from the newsletter sent out the the entire company.
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
April 10, 2015 at 6:58 am
Taking filegroup backups and restoring them to a consistent point requires log backups so that the DB can be brought to a consistent point in time. It's so that any...
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
April 10, 2015 at 6:01 am
At the time SQL started and tried to open the file, it was being accessed by another process, probably a mis-configured antivirus. Hence it couldn't open the database.
OS error 32...
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
April 10, 2015 at 2:43 am
tom.sage 70179 (4/9/2015)
You are the first DBA that is not surprised that there was no SQL error with this client exception.
I'm not a DBA. 😉
Seems like I need to concentrate...
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
April 9, 2015 at 8:00 am
There won't be anything in the SQL error logs.
Timeouts are a client-side error. It's the application deciding that it has waited too long for the query to complete and aborting....
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
April 9, 2015 at 7:29 am
You want to add the columns as include in the nonclustered index to avoid lookups.
Bear in mind, lookups may be fine, it depends how many rows are affected by 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
April 9, 2015 at 3:32 am
Brandie Tarvin (4/8/2015)
GilaMonster (4/8/2015)
Does this answer your question?Those are two instances on the same server, one 2012 and one 2014 and I opened both from the same SSMS 2014
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
April 9, 2015 at 3:16 am
Sure thing. I'm leaving work in the next 30 min or so, bug me in the morning (your morning is fine) and I'll check them (they're behind Outlook, so I'll...
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
April 8, 2015 at 9:06 am
Viewing 15 posts - 6,211 through 6,225 (of 49,552 total)