Standard Members

Pro Members SQL Server Standard Members

Useful undocumented SQL Server 2017 extended stored procedures

Useful undocumented SQL Server 2017 extended stored procedures In this article, you can find the description of some useful undocumented SQL Server 2017 extended stored procedures. xp_availablemedia This extended stored procedure returns available drives and free space in bytes on these drives. In comparison with xp_fixeddrives, the xp_availablemedia extended stored procedure returns not only the hard drives, but all available...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

What Makes Email Marketing Effective?

This question came from a small business owner. What makes email marketing effective? What are the best tips for email marketing success? What is the best sales automation tool for email campaigns? Effective email marketing is done by connecting with your target market or niche group of people. Therefore, you need to clearly articulate your perfect client base. Create a...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2017 DBCC Commands (Part 2)

Useful Undocumented SQL Server 2017 DBCC Commands (Part 2) In this article, you can find the description of some useful undocumented DBCC commands, and find out how you can use these commands in SQL Server 2017. 1. DBCC addinstance This DBCC command can be used to add an object instance to track in Performance Monitor. Syntax: DBCC addinstance (objectname, instancename)...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

How to Grow Your Business with Minimal Investment

How can I grow my business with minimal investment? I have started my event management services business but I’m not sure how to convert genuine leads without much investment. It’s very easy to create a profitable business today without much investment, especially for event management services. Here are some things that you need to explore for most businesses. · Identify...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2017 DBCC Commands (Part 1)

Useful Undocumented SQL Server 2017 DBCC Commands (Part 1) In this article, you can find the description of some useful undocumented DBCC commands, and find out how you can use these commands in SQL Server 2017. 1. DBCC CONFIG This command shows the server’s level DS_CONFIG information. The DBCC CONFIG returns the same DS_CONFIG information as the DBCC RESOURCE returns,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Which Business Should I Focus on First?

This question came from a professional. What kind of business should I focus on first? I plan to create a variety of companies from Construction contracting, service, and manufacturing as well. I’m just not sure which to do first or how to. Any advice and feedback are more than helpful. If you do not have a solid business plan, that...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Useful SQL Server 2017 trace flags

Useful SQL Server 2017 trace flags There are 3 types of trace flags in SQL Server 2017: query trace flags global trace flags session trace flags Query trace flags are active for the context of a specific query. A global trace flag is enabled for the entire time SQL Server 2017 service is running and is applied to each of...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Tips to work with SQL Server 2017 alerts

Tips to work with SQL Server 2017 alerts SQL Server 2017 writes the events into the Windows Application log. SQL Server Agent checks the Windows application log for SQL Server events. When an event occurs, the SQL Server Agent checks if the appropriate alert exists and if so perform the defined response. Alerts can be used to execute a SQL...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

10 Things You Can Do to Create Traffic to Your Website (Part 2)

This question came from a professional. Who can help me create traffic to my website? I need someone to help me with marketing my website. I have a website designer who is working for me but looking for more advise or recommendations. This is a continuation from the initial 10 Things you can do to create traffic to your website...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Tips for using SQL Server 2017 distributed queries

Tips for using SQL Server 2017 distributed queries Try to avoid using the TOP clause in the distributed queries. Because distributed queries that involve the TOP clause are never delegated to an OLE DB provider and are always evaluated locally, you should avoid using the TOP clause in the distributed queries to increase the local SQL Server performance. The first...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here