Viewing 15 posts - 17,626 through 17,640 (of 49,552 total)
The short answer is, there's no such hint as "NoCompile" and trying to run "EXEC <SomeProcedure> WITH NoCompile" will just get you an error message saying "Incorrect syntax near 'nocompile'."
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
July 16, 2012 at 5:32 am
No idea, which boxes did you tick and what options did you select? Is there another instance on the server? If so, what's it called?
(it won't automagically show up...
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
July 16, 2012 at 4:50 am
Maybe, depends if there are problems or not. If no problems, then no.
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
July 16, 2012 at 4:48 am
Usually IO related, someone fiddled with permissions or the drive with the log file on didn't come online/failed/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
July 16, 2012 at 4:15 am
Read this (http://msdn.microsoft.com/en-us/library/ms187101%28v=sql.105%29) and everything under it, and that chapter that Anthony suggested. Also SQL Server 2008 Internals – Chapter 10
Two I will address.
how do you unlock
You don't. SQL Server...
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
July 16, 2012 at 4:14 am
The diff will be based on the backup that you restored.
So let's say you have this scenario:
Full backup 1
Full backup 2
Restore of Full Backup 1
Differential backup
Then to restore the diff,...
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
July 16, 2012 at 3:52 am
What specifically are you unsure on?
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
July 16, 2012 at 3:33 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
July 16, 2012 at 3:28 am
SELECT <other columns> FROM
(SELECT
<other columns>,
ROW_NUMBER() OVER (PARTION BY unit ORDER BY ID DESC) AS RowNo
FROM <Some...
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
July 15, 2012 at 11:35 am
CELKO (7/15/2012)
The short answer is that UDFs and other non-declarative proprietary Microsoft extensions cannot be optimized. They get executed row by row, hence scans.
Incorrect and a non-sequitur fallacy.
While data-accessing...
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
July 15, 2012 at 11:04 am
The Constant Scan operator just generates any constant values necessary for the query. They're not table scans, they have just about no performance impact.
If you're looking for the source 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
July 15, 2012 at 10:54 am
There have been reported cases where not having the updated table in the from clause has resulted in really odd, inefficient execution plans.
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
July 15, 2012 at 3:54 am
Qualify your column names. I'm going to guess that the MedianCo in the subquery should be from the Total table?
update TblGas
set TblGas.MedianCo=
(SELECT t.MedianCo
FROM TblGas AS tg INNER JOIN
Total AS t...
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
July 15, 2012 at 3:00 am
yup (7/14/2012)
Yep though've used those but was looking for an easier way, in lots of cases with me mostly on SQL 2000.
On SQL 2000 CheckDB doesn't run CheckCatalog, so you'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
July 15, 2012 at 2:57 am
Welsh Corgi (7/14/2012)
When you say for the second do you mean that I would need a 3rd party tool for the SSIS Transfer of Data?
As I said, SQL column encryption...
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
July 14, 2012 at 12:29 pm
Viewing 15 posts - 17,626 through 17,640 (of 49,552 total)