Viewing 15 posts - 8,506 through 8,520 (of 49,552 total)
krypto69 (7/8/2014)
Our procs typically have the 'USE [DATABASE NAME]. So they will no longer work.
How does a procedure have a USE statement inside it?
CREATE PROCEDURE Test
AS
USE master
SELECT * 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
July 8, 2014 at 2:59 pm
The Dixie Flatline (7/8/2014)
I abandoned any thoughts of playing it when I realized I already have a job.
🙁 EVE hasn't taken over my life. Not entirely anyway. 🙂
But I...
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 8, 2014 at 2:15 pm
Why do you need to rename your objects? Do you have a naming standard that requires the server name to be part of table or procedure names?
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 8, 2014 at 2:11 pm
The Dixie Flatline (7/8/2014)
GilaMonster (7/7/2014)
EVE OnlineThat's one of his more comprehensible posts.
Wolfkill needs to know if there are tanks in EVE Online, as well as bombers.
Tanks are very important. ...
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 8, 2014 at 1:58 pm
Object explorer. Right click the DB, select the Files tab. Yes, it is advisable to change it if badly set.
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 8, 2014 at 1:58 pm
Basically, buffer pool. SQL caches data in memory and works off that. It won't go to disk unless what it needs is not in the buffer pool.
You got lucky. 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
July 8, 2014 at 1:52 pm
The function CallbackService_ufn_GetCallerData throws an error?
What's the definition of the function?
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 8, 2014 at 7:59 am
You can't parameterise table or column names. You'll have to build up the string with those values in (and beware SQL injection vulnerabilities)
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 8, 2014 at 7:52 am
Fail as in throw an error? Fail as in give incorrect results? Fail as in the server self-destructs?
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 8, 2014 at 7:50 am
As far as i know sys.dm_db_index_usage_stats should have one record per table and index
No. It has one row for each index which has been used since SQL last started. 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
July 8, 2014 at 5:59 am
Not really much you can do other than remove the need to sort entirely, and that may not be acceptable. Sort needs a lot of workspace memory so it tends...
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 8, 2014 at 5:17 am
What operator?
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 8, 2014 at 4:37 am
From the Stack Overflow link:
Remember that the salt should be cryptographically random so I would not recommend using NewId(). Instead, I would generate that using something like .NET's RNGCryptoServiceProvider class.
Email...
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 8, 2014 at 12:24 am
C2 audit enabled?
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 8, 2014 at 12:21 am
Giova (7/7/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
July 7, 2014 at 3:08 pm
Viewing 15 posts - 8,506 through 8,520 (of 49,552 total)