Viewing 15 posts - 301 through 315 (of 476 total)
The only operation permitted in the EXEC command is to concatenate strings.
So you would have to add your two variables first, and then use THAT parameter in the EXEC command
September 21, 2015 at 3:45 am
GilaMonster (9/21/2015)
Rebuild the clustered index.
What happens in this instance if there is no clustered index (i.e. a Heap)?
We always have clustered indexes, so its only curiosity to enquire about how...
September 21, 2015 at 3:41 am
Yet Another DBA (9/21/2015)
Now they are going down the route of MySQL with just tables
Couldn't they do that, and stick with MSSQL? I'm interested in what the factor is...
September 21, 2015 at 12:59 am
PS If it all works fine then try logging in as User = "da" Password="123456" and check that the SQL Query runs OK for that user
September 21, 2015 at 12:32 am
I would put PRINT statements after
SET @DyQuery=...
and before
EXEC xp_cmdshell @command
to see what those two variables contain. I would then try them manually, which will show errors more clearly, and...
September 21, 2015 at 12:31 am
GilaMonster (9/20/2015)
p.s. Emphasising because it's SO important. You're storing the passwords hashed, not plain text?
I find it scary on sites where I do a "lost password" request and I then...
September 20, 2015 at 12:16 pm
robinwilson (9/19/2015)
We ran a process on both systems twice and it was between 50-60% faster after we had created the indexes.
I would have expected a considerably better improvement than that....
September 20, 2015 at 2:33 am
J Livingston SQL (9/19/2015)
+100 for Xenoforo
🙂
the email alert actually contains the content of the new post...amazeballs.........;-)
Discourse has that too. I'm not a fan ... I'm dyslexic, I frequently change...
September 20, 2015 at 2:27 am
GilaMonster (9/19/2015)
protecting against SQL Injection is done, in most cases, by ensuring that it is parameterised, except for the rare scenario where the user input can be white-listed.
We parametrise...
September 20, 2015 at 2:17 am
How long to copy the database from Remote to Local, and then to copy it back again afterwards?
If that is a long time (big database, slow network) then one way...
September 20, 2015 at 2:10 am
Can you have an Indexed View in another database?
Sorry, being lazy I haven't checked, but my recollection is "no"
If that is the case is there some other, cool :-), way...
September 19, 2015 at 4:41 am
I think the biggest problem (once SQL Injection is protected against) with dynamic SQL is if the queries are not parametrised.
Running
SELECT Col1, Col2, ... FROM ORDERS where CustomerID=123
SELECT Col1, Col2,...
September 19, 2015 at 4:32 am
shamshad.ali (9/18/2015)
My question is do I need to use no lock hint in this situation.
I think there are two issues with NOLOCK which I refer to as well-known and...
September 19, 2015 at 4:20 am
Is it just Backups? if so could it be that the backups used to be compressed but are not now? Compressed backups need a lot less I/O (both during Backup...
September 19, 2015 at 3:54 am
I don't know if it counts as "refactoring", but parts of our core-code were written 15 years ago and with-what-we-know-now we would have done it differently/better 😎
In some instances the...
September 19, 2015 at 3:48 am
Viewing 15 posts - 301 through 315 (of 476 total)