Viewing 15 posts - 421 through 435 (of 49,552 total)
Please don't ever do that. There's a critical security flaw in your code (SQL Injection). NEVER concatenate parameters into a string and execute the string.
Have a look...
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 24, 2018 at 9:13 am
WAITFOR DELAY '00:00:10';
SELECT 1/0;
Yours fails instantly because the last query throws a parsing error, and the batch is parsed before any part of it starts...
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 24, 2018 at 7:12 am
Keep in mind that if you have any monitoring tools that calculate the change in wait stats over periods in time, clearing them will break the tool.
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 24, 2018 at 7:03 am
You should be learning constantly. Whether it's R or Python (I prefer R) for data work that can't easily be done in the DB engine, or Powershell/Bash for automation, or...
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 24, 2018 at 7:01 am
To be clear, Daniel, what you probably want to do is, each night download the .trn files from that day, and restore them in order WITH STANDBY. That'll give 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
January 24, 2018 at 5:43 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
January 24, 2018 at 5:42 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
January 24, 2018 at 5:39 am
No, that's the table (index 1 is the clustered index)
You can try dropping the clustered index, but do it on a copy of the DB, not the production...
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 24, 2018 at 5:36 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
January 24, 2018 at 5:28 am
I don't reset them when doing monitoring. I record them at intervals and calculate what changed in those intervals
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 24, 2018 at 5:06 am
Daniel Tuma - Tuesday, January 23, 2018 10:45 PMHave I got this all wrong? Can we do Full, Diff, Diff, Diff...?
You can,...
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 24, 2018 at 2:39 am
I'd probably start with an Extended Events session to capture exactly what statements are run by each, and get their execution characteristics.
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, 2018 at 11:58 am
Corruption is usually related to problems with the IO subsystem.
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, 2018 at 11:48 am
Min memory has nothing to do with cached plans or plan size.
I strongly recommend that you leave that setting alone.
In a busy OLTP system, most queries...
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, 2018 at 10:28 am
That's how identity works. You can and will have gaps, and those gaps are expected. The identity value should be meaningless and not something taken to have some relation to...
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, 2018 at 10:23 am
Viewing 15 posts - 421 through 435 (of 49,552 total)