Viewing 15 posts - 2,881 through 2,895 (of 49,552 total)
Please post new questions in a new thread. Thanks
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
June 28, 2016 at 4:11 pm
Can you post the deadlock graph?
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
June 28, 2016 at 11:29 am
David92595 (6/28/2016)
Are their any other good ways to stop a sql injection?
Yes. Don't concatenate input into strings to be executed unless completely unavoidable (eg table names and column names), 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
June 28, 2016 at 11:28 am
There's probably some implicit conversion happening somewhere in the LINQ such that the value is getting cast to the LINQ equivalent of DATE before the insert.
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
June 28, 2016 at 7:34 am
You need Dynamic SQL, you can't parameterise a table name. Build up a string, execute it.
And yes, people are paranoid for good reason, which is why you will check that...
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
June 28, 2016 at 6:44 am
Can you use Profiler to show the exact INSERT sent to 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
June 28, 2016 at 6:41 am
IF @State = 'AZ'
UPDATE AZ_Fees
SET @ColumnName = @NewValue
WHERE ID = @ID
IF @State = 'CA'
UPDATE CA_Fees
SET @ColumnName = @NewValue
WHERE ID = @ID
...
Alternately, use dynamic SQL and check that the table name...
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
June 28, 2016 at 6:20 am
DATETIME is accurate to 3 milliseconds. It won't convert a time to midnight
Check the LINQ make sure there's no rounding/conversion happening. Also check there's no trigger on the 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
June 28, 2016 at 6:16 am
What's the exact error message?
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
June 28, 2016 at 4:45 am
Can't see the image, but don't use Task Manager. It lies.
Performance monitor, the process object should help. It'll probably take a lot or work.
Increasing memory will help, bump to 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
June 28, 2016 at 3:38 am
And the second query?
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
June 28, 2016 at 2:57 am
hadihalim90 (6/27/2016)
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
June 28, 2016 at 2:50 am
If you run these, what's the result for the database you have the problem with?
DBCC SQLPERF(LogSpace)
SELECT name, log_reuse_wait_desc from sys.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
June 27, 2016 at 10:21 am
angelreynosog (6/27/2016)
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
June 27, 2016 at 9:46 am
What recovery model are you in?
How often do you back up the transaction log?
What's the maximum allowable data loss for this DB, in the case of a disaster?
Please take 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
June 27, 2016 at 8:08 am
Viewing 15 posts - 2,881 through 2,895 (of 49,552 total)