Viewing 15 posts - 256 through 270 (of 687 total)
If the data files are all in the same file group, there's nothing you can do. The engine handles data file fill rates and all that good stuff.
Check this link...
March 26, 2012 at 6:56 am
After importing your CSV [testcsvt], I used Jeff's splitter and I was able to sum the prod-qty for each tranid. It's set based so no looping!
With a little tweaking, you...
March 23, 2012 at 11:29 am
Sounds more like you want a function instead of a procedure.
Can you post your procedure script so we know what it is doing?
March 23, 2012 at 9:09 am
Yea, I can't test the script because I don't have your tables. You can script the tables by going to the object explorer and right click > script table as...
March 21, 2012 at 9:37 am
Alright, still flying blind without your table scripts which would make this tons easier.
I added a join to a derived table which sorts the clients by their most recent dateOpened...
March 21, 2012 at 8:57 am
Give this a go
SELECT
ROW_NUMBER() over(partition by l.surname + ' ' + left(l.forename,1) order by c.dateopened) num
, c.MainCaseRef
, l.Surname + ' ' + LEFT(l.Forename, 1)...
March 20, 2012 at 2:23 pm
You'll need to use a ranking function. Perhaps posting your script will make it a bit easier for these kind folk to help you out.
DDL would be even better!
March 20, 2012 at 1:03 pm
It is very simple. You'll need an IP address and a disk resource to setup the MSDTC resource. This site is a pretty good walk through for the process. Check...
March 20, 2012 at 10:31 am
SET @staffid = 1000
SELECT * FROM TABLE WHERE Staffid = coalesce(@staffid,staffid)
This should work. Gail Shaw has a more efficient way of handling it via secure dynamic SQL. I'll look for...
March 20, 2012 at 8:05 am
Gotta have a couple fresh disks for the new instance. If you install the second instance on the same disks as the first (which can be done after installation I...
March 20, 2012 at 7:19 am
You would install it just like you installed the first instance. Installation > New SQL Server Failover Cluster Installation.
There are prerequisites you need to meet before hand that have to...
March 20, 2012 at 7:01 am
Instances per computer. Scroll down and you'll see 50 instances per computer or 25 per failover cluster.
March 20, 2012 at 6:51 am
john.arnott (3/19/2012)
Here in San Francisco, we're seeing the same story in football with the Niners signing thirty-five year-old Randy Moss after a year of "retirement"
Moss at one point in time...
March 20, 2012 at 6:34 am
Markus (3/19/2012)
Yea... but you are not a multi-millionaire already though.
no?
...
I'm not 🙁
I'd like to think that if I was set for life, I'd still occupy my time doing something...
March 19, 2012 at 11:13 am
Viewing 15 posts - 256 through 270 (of 687 total)