Viewing 15 posts - 8,071 through 8,085 (of 49,552 total)
Because you can't concatenate within an EXEC
DECLARE @b-2 INT;
DECLARE @action VARCHAR(100);
DECLARE @dbname VARCHAR(100);
DECLARE @a INT;
SET @dbname = 'adt';
SET @action = 'dfgf';
SET @a = 14;
SET @b-2 =12;
DECLARE @Result VARCHAR(500);
SET @Result =...
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
August 18, 2014 at 5:20 am
Ok, couple more steps back and in more detail please?
I'm trying to see if there's another way, because row number won't work the way you're using it. Need 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
August 18, 2014 at 5:18 am
Row number always starts at 1 for any query.
Couple steps back, what are you trying to do here?
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
August 18, 2014 at 4:48 am
What's normal for this server for those counters?
Why are you looking at page faults specifically? Do you have a lot of non-SQL apps on the server which are getting paged...
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
August 18, 2014 at 4:48 am
Andrew G (8/18/2014)
Trace flag 845 needs to be enabled in standard edition for LPIM to work.
Locked pages may not be required here.
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
August 18, 2014 at 4:45 am
No indexes, so a heap?
You've probably run into the scenario where pages aren't deallocated after deletes. Create a good clustered index, see if that fixes the problem
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
August 18, 2014 at 3:06 am
Did you read the blog post I referenced?
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
August 18, 2014 at 3:04 am
senthil kumar d (8/18/2014)
Yes. There are 16 seperate physical drives on which the files are distributed.
I do hope they're not 16 individual drives each with one filegroup on. If...
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
August 18, 2014 at 2:38 am
chandumca54 (8/18/2014)
But you should be careful in case Of BULK OPERATIONS as they are minimally logged to log file.
Not when there's transactional replication.
p.s. 3 year old thread.
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
August 18, 2014 at 2:35 am
Chowdary's (8/17/2014)
Can anyone explain the difference between Incremental Backup and Sequential Backup ...
In what context did you encounter those terms? Neither is a SQL Server term.
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
August 18, 2014 at 2:33 am
Possibly safe to ignore. See http://blogs.msdn.com/b/psssql/archive/2009/05/12/sql-server-reports-working-set-trim-warning-message-during-early-startup-phase.aspx
Last line mentions this can be seen on servers with no user 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
August 18, 2014 at 2:31 am
If you're interested in engaging a company to do this for you, drop me a PM and I'll give you my boss's email. I'm in South Africa, but have 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
August 17, 2014 at 3:08 pm
AFAIK, the last backup date comes from MSDB and the data in MSDB is not synced across an AG.
You can sync the data yourself, the backup history tables in MSDB...
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
August 16, 2014 at 1:28 pm
curious_sqldba (8/15/2014)
So you are saying point in time recovery for a partitioned db will take longer time as it will have hardened transactions for all the partitions.
No, I said nothing...
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
August 15, 2014 at 4:44 pm
curious_sqldba (8/15/2014)
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
August 15, 2014 at 4:24 pm
Viewing 15 posts - 8,071 through 8,085 (of 49,552 total)