Viewing 15 posts - 16 through 30 (of 140 total)
jeffrey yao (8/28/2015)
But from pure technical perspective, I feel there is one special deficiency I do not like,...
September 24, 2015 at 10:34 am
Actually, the title is misleading in another perspective, it is not "... into Excel..", it is simply into a CSV file.
If it is indeed an Excel file, I'd say...
September 8, 2015 at 4:11 pm
This is a nice article that generates lots of interesting discussions and topics.
But from pure technical perspective, I feel there is one special deficiency I do not like, that is:...
August 28, 2015 at 10:45 am
Though I like the combination of PowerShell and SMO, I still believe many basic stuff, such as create db, table, user etc are better-handled via t-sql.
I somehow consider PS (with...
April 22, 2015 at 4:04 pm
Really love this SQLCLR series. Many thanks Solomon for your hard-work.
March 13, 2015 at 12:08 pm
I will first try to understand the environment I will manage, such as how many sql instances, SSAS/SSRS/SSIS instances I need to take care of, what are their version /...
February 12, 2015 at 12:48 pm
MysteryJimbo (1/7/2015)
Briefly, my way which I believe to...
January 7, 2015 at 1:52 pm
Matt Slocum (1/6/2015)
To run this manually, it's...
January 6, 2015 at 10:11 am
So after you have modified the two properties, allow_anonymous and immediate_sync, you do not change them back to what they were before? Does this have any potential impact to your...
January 5, 2015 at 1:24 pm
Indeed, both the quantity and quality of the original content on SSC seem to deteriorate over the years. There needs some brainstorming to come up with better ways to address...
September 5, 2014 at 5:18 pm
Nice to use stored procedure to add registered servers.
But if you want to use PowerShell, you can check my article at: http://www.mssqltips.com/sqlservertip/3252/automate-registering-and-maintaining-servers-in-sql-server-management-studio-ssms/
It can be a good complementary...
August 18, 2014 at 12:29 pm
At one time, I did this as well. The scenario was a complex environment with lots of FKs on a few 800+ million row tables, any update/insert/delete becomes slow and...
April 11, 2014 at 5:06 pm
Jeff Moden (3/19/2014)
jeffrey yao (3/19/2014)
Indeed, throwing more resources (hardware or better technology, like upgrading from standard to enterprise edition)...
March 19, 2014 at 2:38 pm
"putting lipstick on a pig", haha.. LOL, very well said Kurt.
Indeed, throwing more resources (hardware or better technology, like upgrading from standard to enterprise edition) is usually the easiest...
March 19, 2014 at 1:36 pm
MS actually does have "TempDB in RAM" today. It defaults to that and only spills to disk if it gets too large for a given session. That's actually...
March 19, 2014 at 11:19 am
Viewing 15 posts - 16 through 30 (of 140 total)