Viewing 15 posts - 5,761 through 5,775 (of 49,571 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.
May 27, 2015 at 8:28 am
Kyrilluk (5/27/2015)
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...
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)
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...
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...
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...
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...
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...
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? ....
May 27, 2015 at 2:31 am
ALTER TABLE ... ALTER COLUMN doesn't recreate the table. It changes a single column.
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...
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
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.
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.
May 26, 2015 at 3:32 am
Viewing 15 posts - 5,761 through 5,775 (of 49,571 total)