The award-winning SQL Developer Bundle contains 12 tools for faster, simpler SQL Server development. Download a free trial.
Got backup questions? Don’t be shy!
Read Grant Fritchey’s SQL Server Backup Questions We Were Too Shy To Ask and get the answers to some of life’s big questions like, "How do I retrieve a table from the log?" and, "Are SAN backups enough?" Download the full article PDF.
Generate realistic test data, fast
“In less than the time it took me to get my coffee, I had a database with 2 million rows of data for each of 10 tables.” Stephanie Beach, QA Manager. Try SQL Data Generator now.
This industry-first T-SQL source code unscrambler automatically reads the details hidden in T-SQL stored procedures without altering the source code. With this granular information, it generates organized and precise data flow diagrams along with plain-language descriptions of each programming step within any database object. Resulting documentation can be generated in PDF, Word or HTML. More »
Ace your preparation for Microsoft® Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options.
Maximize your performance on the exam by learning how to:
Create database objects
Work with data
Troubleshoot and optimize queries
You also get an exam discount voucher—making this book an exceptional value and a great career investment.
Yesterday's Question of the Day
(by Steven Neumersky):
A week of Analysis Services
You have deployed a cube successfully, but your users tell you "it does not make sense to roll up a certain attribute hierarchy in the currency dimension to "ALL". What property must you change in order to disable that attribute's "ALL" level while keeping the rest of its attribute hierarchy intact?
Answer: IsAggregatable set to False on attribute at the top of the hierarchy
The presence of an (All) level in an attribute hierarchy depends on the IsAggregatable property setting for the attribute and the presence of an (All) level in a user-defined hierarchy depends on the IsAggregatable property of the attribute at the top-most level of user-defined hierarchy.
Setting the AttributeHierarchyEnabled to "False" would indeed remove the ALL level, but it would remove the whole entire attribute hierarchy. Had this attribute been used in a natural hierarchy in the same dimension and become redundant and confusing as its own attribute hierarchy, then setting the AttributeHierarchyEnabled to "False" would have been the most appropriate move.
Cant figure how to pull out unique values from 3 tables
- Hi All I have this code
from fonehub f,
MobilePhoneCompany m ,
where f.product_name = 'Nokia C7'
and m.product_name = 'Nokia C7'
Troubleshoot sp that hangs
- I have a fairly simple procedure with 4 if statments and code for each.
When I run the procedure in a...
Copy DB from QA to Prod
- I just implemented TDE on one of the DB in our Prod environment, will this cause any issue if I...
SQL Job reports strange results
- I've created the following script to report on the status on SQL logins:
@subject = 'ED - SQL_Logins_Report',
@profile_name = 'XXXX',
last 6 months data
Below is my table structure,
Table Name : MemberVisit
select * from(
select 1 as Id,'2014-01-13' as Visiteddate,20 as PutchaseAmount
select 1 as...
Query to find blocking is getting blocked.
- I have this query to find blocking:
SELECT DISTINCT sp.spid SPID, sp.blocked BlockingSPID, DB_NAME(tl.resource_database_id) DatabaseName, es.Status
, (SELECT Text FROM sys.dm_exec_sql_text(sp.sql_handle)) SQLText
Failed install - 2008 Standard
As title. Failed during an install of only Client Tools Connectivity and Management Studio Complete.
Can't uninstall as it says it...
reports from database
Is there any feasibility to take hourly data capture in the form of reports from database wherein we can get...
- I have a sql cluster and it has about 500 sleeping spid, what should I do? Thank in advance.
- I have a SPID 18 doing checkpoing for a user database since last server reboot. There is no related error...
CLR assembly DLL file location? Corrupted
CLR file location.
Is it C:\windows\Framework\version?
Frequently facing problems SSIS - backup package dll files are corrupted and maintenance plan not taken automatically...
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.