This tip looks at some of the questions around attribute relationships in SQL Server Analysis Services, including why you need them, how to create them, and the common data sets involved.
2014-12-19
7,646 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/jBulinckx/indexedviewswithouterjoins.asp
2005-05-04
66 reads
Well I finally got it to work with the help of a co-worker...here is the code previous_discharge_date = (SELECT MAX(ISNULL(referral_ref.dischargedate, '')) as previous_discharge_date FROM referral as referral_ref WHERE referral_ref.dischargedate <>'2078-12-31 00:00:00' AND referral.memid = referral_ref.memid), I was making it way more complex than it needed to be... Thanks to everyone for the help Leeland
2005-04-22
Are you actually dropping the original table? In the "Select into" you get all the data. As long as you don't drop the original table, if you want to back off the the import, you would just do: TRUNCATE TABLE TableName GO INSERT INTO TableName SELECT * FROM NewTableName GO The indexes, keys etc. should […]
2005-04-11
I need to delete millions of rows from a table older than x days. I broke this up into smaller delete batches like the following.SET ROWCOUNT 1000 WHILE 1 = 1 BEGIN delete from events where datediff(day, EVENT_DATE, getdate()) > 10 IF @@ROWCOUNT = 0 BREAKENDSET ROWCOUNT 0Would this lock the table at […]
2005-04-11
7 reads
Read the BOL section titled "BEGIN DISTRIBUTED TRANSACTION"And also the section titled "SET REMOTE_PROC_TRANSACTIONS"
2005-03-14
the following article could possibly help (it's about using AS and RS, look towards the end re: actions) but will depend a little on how dynamic you need to query. If it's only ever going to return customers etc, then this may work for you.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp steve.
2005-02-20
print 'Free Space' print '----------' exec master.dbo.xp_fixeddrives print 'Memory' print '------' exec master.dbo.xp_msver print 'Database Configuration' print '----------------------' exec master.dbo.sp_configure print'DB Size' print'-------' exec master.dbo.sp_databases print 'Linked Servers' print '--------------' exec master.dbo.sp_helplinkedsrvloginprint 'Windows info' print '------------' exec master.dbo.sp_server_info
2005-02-16
Triggers do not monitor data. They only run on table for an insert, update, or delete transaction.Can you explain what the table holds?Is it a table that holds a single row of configuration data or is it the "timetoSend" column hold values for multiple rows?
2005-01-27
Select datename (dw, Entrydate) as 'Day of week' , count(OrderNo) as NumberFrom [order-header]Where (SUBSTRING(source, 1, 8) = '223WHOLE')and EntryDate bewtween '20040101' AND '20041231' GROUP BYdatename (dw, Entrydate)
2005-01-23
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers