Viewing 15 posts - 10,891 through 10,905 (of 49,552 total)
Yes
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
November 19, 2013 at 10:20 am
Max server memory limits the buffer pool. SQL uses additional memory over and above the buffer pool for things like thread stacks, backup buffers, linked server drivers and other. It's...
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
November 19, 2013 at 7:19 am
Junglee_George (11/19/2013)
Ok..Thanks Gila for the information.But If I change the code this way, it is not showing the message:
DECLARE @SomeValue nvarchar(4000) = ' '
SELECT isnull(@SomeValue,'The variable is null');
Well, no, 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
November 19, 2013 at 2:34 am
IsNull can be used on NVarchar columns, it can be used on any data type. It works fine on nvarchar
DECLARE @SomeValue nvarchar(4000);
SELECT isnull(@SomeValue,'The variable is null');
What exactly is 'not working'?
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
November 19, 2013 at 2:17 am
Snapshots are not primarily there to prevent data loss. Start with a good solid backup strategy, full and log backups.
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
November 18, 2013 at 11:41 pm
homebrew01 (11/18/2013)
My goal is to make best use of the 4 G ram that I have, and address the apparent Linked Server issues I am having.
Long-term recommendation - upgrade 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
November 18, 2013 at 10:21 pm
Post the exact update you're running, because the two above will not update the values to null unless the parameter is null and the column value is already null
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
November 18, 2013 at 5:45 am
homebrew01 (11/18/2013)
"Total Server Memory (kb)" shows a flatline at "100" in the graph. The "last", "avg", "min" and "max" boxes all show 3.2...
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
November 18, 2013 at 5:18 am
Task manager lies. Don't use task manager to check SQL Server's memory usage, it will often show far too low (limitation in Task Manager). Use performance monitor and the Total...
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
November 18, 2013 at 4:58 am
If you're going to add -g700, I would suggest dropping that to 2.5GB. Otherwise, 3GB for SQL buffer pool, 700MB for the MemToLeave, doesn't leave much for the OS.
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
November 18, 2013 at 4:45 am
It's not limited to web apps, and by the looks of your update, your code is vulnerable. Do not concatenate user input into a sql statement that will be executed....
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
November 18, 2013 at 4:04 am
Aside, do you know how vulnerable that is to SQL injection attacks?
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
November 18, 2013 at 3:47 am
Get the vendor's permission before you make any chances and ensure that you're not breaking support agreements.
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
November 18, 2013 at 3:45 am
Nothing wrong with that query. Let me guess, you're running it from a database with compatibility level set to 80. If that's the case, change the database context to master...
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
November 18, 2013 at 3:21 am
adeel.imtiaz (11/18/2013)
You are right. Is it possible for you to send me the CP of 10.52.4000 so that i can run it on CLIENT MACHINE.
You can get service packs from...
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
November 18, 2013 at 1:17 am
Viewing 15 posts - 10,891 through 10,905 (of 49,552 total)