Viewing 15 posts - 6,496 through 6,510 (of 8,731 total)
Study, practice, be sure to know everything that you need and attend the certification exams.
Vague answer to vague question.:-)
May 9, 2014 at 4:28 pm
What would happen if someone sets the value of ZoneName to
'; DELETE TABLE IPPOOL;
Don't try this on a production environment.
You might want to read about SQL Injection to prevent this...
May 9, 2014 at 12:59 pm
From what I can understand, you're trying to limit the upper value of type 1 to 24 and types 2 and 3 to 48.
This should do the trick.
Case when Avg...
May 9, 2014 at 12:51 pm
Sean's code will work just fine as a join to a table that contains the ranges.
An iTVF as suggested by him, might get some performance improvements because you can't never...
May 9, 2014 at 12:47 pm
jcrawf02 (5/8/2014)
WayneS (5/8/2014)
Ed Wagner (5/8/2014)
May 8, 2014 at 10:36 am
Gangadhara MS (5/7/2014)
sp_helpindex 'DML.ExceptionstrackingTable'
IX_DMLIsDeletedFlagganganonclustered located on PRIMARYDMLIsDeletedFlag
IX_gangaddednonclustered located on PRIMARYDMLIsDeletedFlag, OriginalSubscriptionKey
NCIX_ActivationModelnonclustered located on PRIMARYActivationModel, ExceptionType
NCIX_BatchIDnonclustered located on PRIMARYBatchID
NCIX_EntitlementIDnonclustered located on PRIMARYEntitlementID
NCIX_ExceptionsTrackingTable_CalcProductKeyIDnonclustered located on PRIMARYCalcProductKeyID
NCIX_GrpIDChannelIDSeqNononclustered located on PRIMARYGrpID,...
May 7, 2014 at 4:24 pm
I know that this might not be constructive, but I had to ask.
Why do you want that security measure to avoid repeated passwords, but you limit your passwords to 10...
May 7, 2014 at 4:18 pm
I can't understand your logic. There's no way to get to the first desired row: 10000, 'Starting', 9, 1200.0
Could you explain further?
May 7, 2014 at 4:07 pm
I agree on everything that Sean has said.
I guess from my part is that your DISTINCT on 125 million rows is generating problems. This might help, and proper indexing should...
May 7, 2014 at 3:53 pm
sestell1 (5/7/2014)
Hmph. Since the question asked how to remove the filegroup from the database, I didn't consider dropping the database a viable option."Memory-optimized filegroups cannot be deleted."
http://msdn.microsoft.com/en-us/library/dn284308(v=sql.120).aspx
+1
It's like asking...
May 7, 2014 at 3:44 pm
This is just a guess on what you might be trying to do, just a lot simpler and (hopefully) faster.
It inserts everything at once instead of going one item at...
May 7, 2014 at 8:27 am
vanamali (5/7/2014)
It takes lot of time and effort. I was asking that question...
May 7, 2014 at 8:10 am
I can't find a reason to use development time to insert additional line feeds when your mail client shoult format the email correctly.
May 6, 2014 at 12:11 pm
For a deep answer on those questions, I suggest you to go to the books section[/url] in this site. You'll find great resources available there.
May 6, 2014 at 8:18 am
I'm not sure if this is considered simpler. 😉
SELECT duration, SUM(iduration)
FROM (
SELECT duration,
Item...
May 2, 2014 at 4:12 pm
Viewing 15 posts - 6,496 through 6,510 (of 8,731 total)