Viewing 15 posts - 5,761 through 5,775 (of 49,552 total)
SQL-DBA-01 (5/27/2015)
if in the string (passwed) if tge DBA/user passes one or two quotes, could be a trouble.
Not if you use REPLACE.
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
May 27, 2015 at 8:28 am
Kyrilluk (5/27/2015)
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
May 27, 2015 at 8:25 am
mattech06 (5/27/2015)
Can you see any easy optimizing of those statements (I know I haven't posted any data, sorry)
I was about to say 'execution plans, table definitions and index definitions', then...
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
May 27, 2015 at 8:07 am
Kyrilluk (5/27/2015)
Eric M Russell (5/27/2015)
Kyrilluk (5/27/2015)
Eric M Russell (5/26/2015)
Kyrilluk (5/26/2015)
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
May 27, 2015 at 7:58 am
BL0B_EATER (5/27/2015)
Anyone else here been?
Yup. Done IE 1, 2 and 3
I assume a mind-bending experience...
Yup.
Make sure that work knows you're not to be bothered. Nothing worse than spending...
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
May 27, 2015 at 7:23 am
SQLJay (5/19/2015)
but there would be a definite increase in performance due to the number of SQL threads doubling.
False.
SQL is not, in any way, limited to one thread per file. Any...
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
May 27, 2015 at 7:19 am
You can try to delete the documents in question, though I suspect that will throw an error.
If you don't care about losing those two documents, then when you can take...
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
May 27, 2015 at 7:16 am
Not possible. To start with, you have outer joins which aren't allowed in an indexed view
This isn't an Azure limitation, the earthed SQL product has the same long list of...
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
May 27, 2015 at 5:45 am
You'll probably get a far better answer if you post this on the MySQL forums. Try http://forums.mySQL.com. This site is focused on Microsoft SQL Server and most people here will...
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
May 27, 2015 at 5:23 am
WhiteLotus (5/26/2015)
I don’t think eliminate distinct will make any difference ….
By which you mean you've tested it and it didn't make any difference? ....
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
May 27, 2015 at 2:31 am
ALTER TABLE ... ALTER COLUMN doesn't recreate the table. It changes a single column.
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
May 27, 2015 at 2:28 am
itortu (5/26/2015)
I changed my original query to use 23:59:59, and that also gave me the missing record back.
But you'll still miss 23:59:59.006. The alternative suggested with a < on...
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
May 26, 2015 at 12:40 pm
Steve Jones - SSC Editor (5/25/2015)
He has been banned
Was this you then, restoring deleted posts? http://www.sqlservercentral.com/Forums/FindPost1688705.aspx
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
May 26, 2015 at 7:55 am
Nothing wrong with while loops. I'm about to start a batch of WHILE @Done != 0 INSERT INTO ... SELECT TOP (@n) FROM ... on a client's server
Tool...Job.
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
May 26, 2015 at 5:53 am
That's extremely weird and would require a hell of a lot of custom development. Sounds like someone wanted to do things the hard way.
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
May 26, 2015 at 3:32 am
Viewing 15 posts - 5,761 through 5,775 (of 49,552 total)