Viewing 15 posts - 11,536 through 11,550 (of 22,214 total)
Dev (12/7/2011)
Cadavre (12/7/2011)
Dev (12/7/2011)
Welcome to the discussion!But that statement is for a table with 2 rows. 😀
The number of rows is irrelevant, the statement is...
December 7, 2011 at 7:36 am
Dev (12/7/2011)
Ninja's_RGR'us (12/7/2011)
Dev (12/7/2011)
Ninja's_RGR'us (12/7/2011)
Dev (12/7/2011)
Ninja's_RGR'us (12/7/2011)
WHERE Items.ItemCategoryCode IN (SELECT CategoryCode FROM @Cats)Convert to #tbl with PK to help the stats, search and replace...
December 7, 2011 at 6:17 am
Is is possible you have enabled 'optimize for ad hoc workload' on the server? It will store plan stubs the first time a query is executed instead of storing the...
December 7, 2011 at 5:19 am
DoubleEx (12/6/2011)
December 7, 2011 at 5:09 am
Test the restore. Don't assume it's OK. Test it.
December 7, 2011 at 5:06 am
durai nagarajan (12/7/2011)
hope both gives better performanace than cursors.
It depends on what you're doing with them.
December 7, 2011 at 5:04 am
Another option to pursue, and a good plan for your long term skill set development, is to use Extended Events to capture all user activity. It works a lot like...
December 7, 2011 at 5:03 am
GilaMonster (12/6/2011)
Grant Fritchey (12/6/2011)
GilaMonster (12/6/2011)
Grant Fritchey (12/6/2011)
LutzM (12/6/2011)
Ninja's_RGR'us (12/6/2011)
Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! ...
December 6, 2011 at 3:36 pm
GilaMonster (12/6/2011)
Grant Fritchey (12/6/2011)
LutzM (12/6/2011)
Ninja's_RGR'us (12/6/2011)
...Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! 😉
I guess I...
December 6, 2011 at 1:29 pm
I'd say minimum, all projects go through Dev, Staging & Prod. Formal QA might be a luxury, but validating deployments sure isn't.
I listed a number of possible environments and what...
December 6, 2011 at 11:40 am
Ninja's_RGR'us (12/6/2011)
Grant Fritchey (12/6/2011)
LutzM (12/6/2011)
Ninja's_RGR'us (12/6/2011)
...Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! 😉
I guess I...
December 6, 2011 at 10:50 am
Krasavita (12/6/2011)
If you look under this screen there is only one option to use the same account for all sql Services,but how can I go and...
December 6, 2011 at 10:35 am
LutzM (12/6/2011)
Ninja's_RGR'us (12/6/2011)
...Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! 😉
I guess I know why neither...
December 6, 2011 at 10:33 am
LutzM (12/6/2011)
Changing subject: Does anyone know one of the DBAinSpace finalists?There's no name I recognize as one of the Threadizens....
I'm friends with Tim Ford. He's an MVP. He runs SQL...
December 6, 2011 at 10:31 am
December 6, 2011 at 10:26 am
Viewing 15 posts - 11,536 through 11,550 (of 22,214 total)