Viewing 15 posts - 16 through 30 (of 43 total)
As far as the NEWSEQUENTIALID goes, SSCrazy hit most of the points I didn't elaborate on. We have multiple requirements and some of those include the application code generates...
March 20, 2013 at 9:04 am
TheSQLGuru,
I did not intend to spark a debate 🙂 but here are my responses.
TheSQLGuru (3/19/2013)
1) if you are worried with space, GUIDs have no place in your system.
This statement is...
March 20, 2013 at 8:07 am
Why the developer used ISNULL / CAST - not sure. Didn't make sense to me but even without those the execution plan remains the same. I'm...
March 19, 2013 at 9:03 am
Erin Ramsay (3/18/2013)
What about taking the row_number out of vw_BatchItems completely and putting row_number() over (order by DateEntered) in the usp_sel_BatchItems view?
In this case that will not work as the...
March 19, 2013 at 8:56 am
Lynn Pettis (3/18/2013)
March 19, 2013 at 8:54 am
Sorry for the delayed response. I've been working on other items lately. Anyways, here I am :).
@sean - yes I am concerned with storage space but...
March 18, 2013 at 12:31 pm
We had the same dilemma - going from SQL Server 2005 32-bit to SQL Server 2008 64-bit. We found it easiest to do it in steps:
Upgrade OS to Windows...
November 29, 2012 at 7:12 am
@Gila - I'm looking for optimal 🙂 - sorry I wasn't clear on that.
November 26, 2012 at 12:32 pm
FWIW - here is the case study I am referring to.
November 26, 2012 at 11:01 am
@Gila - your comments on the I/O paths are definitely noted. On the CPU side I was referring to how SQL Server manages the multiple backup files - my...
November 26, 2012 at 10:54 am
Thanks for your input everyone. You've helped me confirm my initial direction is valid - backup to disk and then allow our infrastructure group backup the files to tape....
November 19, 2012 at 11:48 am
@Gila: I can provide you with my options but was looking for some general feedback first. Obviously I'd like to rule out options and not focus on them if...
November 14, 2012 at 9:18 am
Just an update, our domains are configured liked so:
ForestA ForestB
...
November 14, 2012 at 7:53 am
This is pretty vague but if you want to know all of the CLR objects on your server you can use this query:EXEC sp_MSforeachdb 'USE [?]; SELECT DB_NAME(), * FROM...
November 8, 2012 at 9:03 am
You can - we do too. We found that the timer job that rebuilds indexes only rebuilds an index once it becomes 30% fragmented. It never does any...
November 8, 2012 at 7:19 am
Viewing 15 posts - 16 through 30 (of 43 total)