Viewing 15 posts - 2,656 through 2,670 (of 5,843 total)
1) if you are worried with space, GUIDs have no place in your system.
2) why aren't you using NEWSEQUENTIALID??
3) Your PK on the parent does a clustered index on the...
March 19, 2013 at 7:57 am
inHouseDBA (3/12/2013)
Gurus, Any more suggestions?
1) My suggestion is that you get a professional on board for a few days to completely review and improve your entire maintenance process. Managing...
March 19, 2013 at 7:50 am
ramyours2003 (3/18/2013)
Can any one explain the SQL architecture
Forums are for short, targeted assistance. Your question is most decidedly neither! :w00t: I could talk for a week straight...
March 19, 2013 at 7:46 am
Eugene Elutin (3/18/2013)
SELECT TransactionID, MIN(VoucherNo) , MAX(VoucherNo )FROM yourtable
GROUP BY TransactionID
Just a small point, but this only works as long as the values are fixed width and zero padded. ...
March 19, 2013 at 7:44 am
sqldba_newbie (3/18/2013)
opc.three (3/18/2013)
Cost estimate compared to the Cost threshold for parallelism setting. The QO is a cost-based optimizer.Thanks. Do you mean Cost from estimate plan?
When a query is first run...
March 19, 2013 at 7:38 am
reddi_arjun (3/18/2013)
Thanks a lot.The script was very helpful.
PLEASE DO NOT DO THIS!!! IT IS A HORRIBLE, HORRIBLE THING TO DO ON YOUR SQL SERVER!!!
March 18, 2013 at 8:02 am
Given the hardware budget squeeze I didn't expect "management" to understand the real value of a good consultant/mentor. Damn shame is about all you can say to that.
Good luck...
March 15, 2013 at 3:36 pm
I'm not sure what happened to this forum, the level of courtesy and respect seems to have dropped off. Perhaps it has become too cliquey.
1) I was (as I...
March 15, 2013 at 3:30 pm
In my experience the best way BY FAR to become an expert (certainly at such a complex system as SQL Server) is to be MENTORED by an expert. So...
March 15, 2013 at 3:13 pm
opc.three (3/12/2013)
Yes, consider hiring someone who has setup DR/HA before to guide you through the process.
+100
March 15, 2013 at 2:29 pm
Thought just occurred to me: have you checked the BIOS settings in both servers to see if there is a difference there that could be causing "identical" machines to not...
March 15, 2013 at 2:27 pm
cryovenom: based on many things in your various posts you (and your company) REALLY REALLY need to do themselves a favor and get a good professional on board to help...
March 15, 2013 at 2:21 pm
Note, this isn't just about the WHERE clause. You can also potentially eliminate complete hits (joins) on tables if you don't actually need to filter on them based on...
March 14, 2013 at 9:41 am
RVO (3/14/2013)
select * from IndustryMap
WHERE 1 =1
AND id_cusip = COALESCE(@cusip,id_cusip)
AND ticker = COALESCE(@ticker,ticker)
AND exch_code = COALESCE(@exchangeCode,exch_code)
and was ready to scream Hurray but realized that
when any of the columns...
March 14, 2013 at 9:39 am
Hmm, I wonder what happens if the codeid's repeat instead of being unique across all 3 code tables. Hopefully the way the aggregates are done will factor the Cartesian...
March 14, 2013 at 7:36 am
Viewing 15 posts - 2,656 through 2,670 (of 5,843 total)