Viewing 15 posts - 706 through 720 (of 1,353 total)
You do intPO or something
As a rule, I don't make non-mathematical numbers integers but strings. Subtracting one PO account from another gets me nothing useful. There is also...
January 21, 2015 at 6:55 am
It's a real fun trip through the code if even one well used column has its datatype changed.
Just because something is difficult on change doesn't mean it's a bad idea....
January 20, 2015 at 2:56 pm
I see this is an old thread, but I also have something to add for future finders on this topic. In addition to having an individual key for the...
January 16, 2015 at 1:41 pm
Like most other respondents, I make good use of PRINT.
January 16, 2015 at 8:35 am
As a minimum, usp_ for user stored procedure would be a good start. I'm not advocating that as the ideal solution. Only that it makes a contrast with...
January 15, 2015 at 11:42 am
Will they speed up the restore process or make them slow?
Backup striping has signficantly increased the speed of my restores.
January 12, 2015 at 8:12 am
From your experience, does striping to a SAN or a single NAS or DAS drive offer the same performance benefit as striping to multiple NAS or DAS drives?
I achieved...
January 9, 2015 at 7:28 am
I recently implemented striped backups based on an article I read on this site for our two nearly 1 TB databases. It reduced the backup and restore time needed...
January 9, 2015 at 7:05 am
I don't know that where I could use the MERGE I would use EXCEPT. I've used EXCEPT a couple of times on permanent queries. The first was to take a...
January 9, 2015 at 7:00 am
I cannot figure out why companies would continue to use SSRS. It takes so long to create simple things that, frankly, are much much easier to do with other tools.
I...
January 5, 2015 at 9:44 am
Yes, that's certainly the simplest solution.
I'm concerned that it might not be correct, though.
Any solution that works is in some sense correct. If a second opinion helps, it...
November 17, 2014 at 7:23 am
Can you provide a concrete examp of this? I'm unsure why you don't simply add to the rows of the fact. I assume there's also a product dimension...
September 24, 2014 at 8:54 am
We can all get our dose of common sense to start the week. Great article!
September 22, 2014 at 6:42 am
Good to know. It had the makings of one with the odd requirements....
August 18, 2014 at 11:36 am
Viewing 15 posts - 706 through 720 (of 1,353 total)