Viewing 15 posts - 4,336 through 4,350 (of 5,685 total)
GSquared (1/18/2011)
...because some poor fool will try to open your multi-terrabyte database file in MS Word...
*sprays coke on the screen* Thanks Gus, you just lightened up my afternoon. :w00t:
January 18, 2011 at 2:49 pm
Use a cte to create a row_Number() expression to number your rows in the correct order. Then link the table to itself to find its row, and the previous...
January 18, 2011 at 2:47 pm
SQL08Kid (1/18/2011)
Grant Fritchey (1/18/2011)
Has to be triggers or something going on behind the scenes.
Grant, what's the best way to see if anything is happening behind the scenes? This happens every...
January 18, 2011 at 2:43 pm
Silly question, Magoo, since this has stayed quiet a bit. If you put the where clause IN the view, and then call the result from the view, do you...
January 18, 2011 at 2:37 pm
Back on topic!!!!
Looks like the new semester's started: http://www.sqlservercentral.com/Forums/Topic1049661-357-1.aspx
January 18, 2011 at 2:34 pm
sqlserver12345 (1/18/2011)
.ldf - tlogbackups files.dfb - differential backup files
.bak -
.mdf -
What is the difference bewteen .bak and .mdf files?
thanks
:ermm:
ldf = log file, not backup.
bak = the backup of the...
January 18, 2011 at 2:32 pm
tacy.highland (1/18/2011)
January 18, 2011 at 2:24 pm
Currently working with a centralized SSIS server. It's rather nice actually.
A) Don't need full sa/rights to create/deal with jobs on the SSIS server on each independent server (we have...
January 18, 2011 at 1:56 pm
Alvin Ramard (1/18/2011)
Craig Farrell (1/18/2011)
jcrawf02 (1/18/2011)
January 18, 2011 at 1:05 pm
sravanb (1/18/2011)
DDL for the table:sal(id int,reportingperiod varchar(10),salary int)
Business rule:
Average salary should be calculated only when if the employees have salary in reportingperiod month january.
This is untested since the ddl and...
January 18, 2011 at 1:05 pm
keymoo (1/18/2011)
description pctAccountChange
--------------------------- ----------------
largestDrawDownPct ...
January 18, 2011 at 1:01 pm
kalpu234 (1/18/2011)
January 18, 2011 at 12:52 pm
For truncating use an Execute SQL task in the main flow.
For updating (especially UpSert) use the Slowly changing Dimension component. It's a wizard that will handle your update/inserts easily.
For...
January 18, 2011 at 12:48 pm
herladygeekedness (1/18/2011)
I am noodling with a package to see how it all works, and have a build done on dev for SQL config and understand I need to copy...
January 18, 2011 at 12:46 pm
jcrawf02 (1/18/2011)
January 18, 2011 at 12:43 pm
Viewing 15 posts - 4,336 through 4,350 (of 5,685 total)