Viewing 15 posts - 1,666 through 1,680 (of 3,738 total)
PaulB-TheOneAndOnly (3/23/2012)
Welsh Corgi (3/23/2012)
PaulB-TheOneAndOnly (3/23/2012)
Welsh Corgi (3/23/2012)
Until today I never saw a Database that contained both the Staging Tables and Data Warehouse Tables in the same Database.
This is common practice...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 3:31 pm
peter 82125 (3/23/2012)
Filestream needs to be installed. That was the problem.
Yeah you have to enable filestream for it to work.
I sent you another link that was not that detailed.:w00t:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 2:28 pm
PaulB-TheOneAndOnly (3/23/2012)
Welsh Corgi (3/23/2012)
Until today I never saw a Database that contained both the Staging Tables and Data Warehouse Tables in the same Database.
This is common practice in "some" RDBMS...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 2:04 pm
Thanks you very much for the information!:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 11:56 am
So you download the file but what steps do you perform to install?
I seem to remember doing something like this:
http://msdn.microsoft.com/en-us/library/aa992075.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 11:16 am
Post moved to a more appropriate forum.
http://www.sqlservercentral.com/Forums/Topic1271897-373-1.aspx
Please do not post here.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 11:11 am
A couple of links on Filestream.:-)
http://www.simple-talk.com/sql/learn-sql-server/an-introduction-to-sql-server-filestream/
http://jobinjohn.blogspot.com/2011/11/filestream-in-sql-server-2008-and.html
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 11:08 am
I wonder what QA's pass rate is for a 5 day class?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 11:03 am
peter 82125 (3/23/2012)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 10:29 am
Did you want 2008 or 2008R2?
http://msftdbprodsamples.codeplex.com/releases/view/55926
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 9:59 am
IMHO, Ralph Kimball is your best bet.
http://www.kimballgroup.com/html/books.html
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 9:56 am
I had already tried restarting the SQL Server Service but no luck.
I used the same script to configure Database mail that I used on another new Server a month ago...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 9:54 am
Lowell (3/23/2012)
all four of my...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 9:18 am
Thanks again. You saved me a lot of time.
I wrote a lot of code to drop & recreate the PK's that someone created and the vendor told me that if...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 8:40 am
PaulB-TheOneAndOnly (3/23/2012)
Welsh Corgi (3/20/2012)
can't you set up a rule to name the Primary Key?Yes you can... check here http://erwin.com/uploads/tips_techniques/Using_Naming_Standards.pdf
Thanks Paul!
So if the naming conventions for a Primary key is...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 7:48 am
Viewing 15 posts - 1,666 through 1,680 (of 3,738 total)