Viewing 15 posts - 5,116 through 5,130 (of 8,753 total)
BL0B_EATER (6/2/2015)
what does SSF mean?
Silver Spoon Feeding
😎
June 2, 2015 at 1:23 pm
Lowell (6/2/2015)
i belive a serverice stop and start of SQL automatically bumps identity seeds by 1000 in SQL2012read about the feature / defect here:
Only seen this with AO, never on...
June 2, 2015 at 1:12 pm
Frank Cazabon (6/2/2015)
I have inherited a system which uses Identity numbers for primary key fields, but also displays them for the user to see. The user has noticed missing...
June 2, 2015 at 11:37 am
Ed Wagner (6/2/2015)
whereisSQL? (6/2/2015)
Revenant (6/2/2015)
DonlSimpson (6/2/2015)
cunningham (6/2/2015)
Ed Wagner (6/2/2015)
cunningham (6/2/2015)
Ed Wagner (6/2/2015)
crookj (6/2/2015)
Eirikur Eiriksson (6/1/2015)
Revenant (6/1/2015)
TomThomson (6/1/2015)
DonlSimpson (6/1/2015)
SprintBorland
Delphi[/quoteZeus
Mercury
Saturn
Megadrive
Sega (had to look that one up)
yeah that was it's name in Europe...
June 2, 2015 at 11:27 am
Thanks for the heads up Jacob
😎
June 2, 2015 at 10:09 am
My bad, I missed the partition by clause which effectively replaces the group by, this code should do the trick
😎
SELECT
CompanyId
,IMNId
,RowNumber
,Sum(Qty) OVER
(
PARTITION BY CompanyId
,IMNId
,RowNumber
ORDER BY CompanyId
,IMoneyNetId
,RowNumber...
June 2, 2015 at 4:58 am
devsql123 (6/2/2015)
I am looking for solution related to get Running Total in SQL Server.
I found that new OVER clause can help, as explained below.
http://blog.sqlauthority.com/2014/10/04/sql-server-how-to-find-running-total-in-sql-server/
SELECT
CompanyId
,IMNId
,RowNumber
,Sum(Qty) OVER(ORDER BY CompanyId,...
June 2, 2015 at 1:44 am
Revenant (6/1/2015)
TomThomson (6/1/2015)
DonlSimpson (6/1/2015)
SprintBorland
Delphi[/quoteZeus
June 1, 2015 at 11:52 pm
Jeff Moden (6/1/2015)
Maybe it's just me. I might be getting too old for this business. I don't understand why people make such ridiculous posts.
That is an SSF if...
June 1, 2015 at 11:08 pm
tcronin 95651 (6/1/2015)
that is kind of the issue, dependent on SAN people so don't want to make mad, however, would like to see after Exchange migration is done
The migration might...
June 1, 2015 at 2:41 pm
tcronin 95651 (6/1/2015)
yeah idera does show wait stats spiking, of course also doing a exchange migration, just trying to see if relationship between blocking and drive issue
Are you anywhere close...
June 1, 2015 at 2:18 pm
tcronin 95651 (6/1/2015)
No physical, not really anything from the SAN but after 15 years of dealing with them realizing like behind the curtain in the wizard of oz world
Wasn't there...
June 1, 2015 at 1:49 pm
djj (6/1/2015)
Eirikur Eiriksson (6/1/2015)
Ed Wagner (6/1/2015)
cunningham (6/1/2015)
Ed Wagner (6/1/2015)
cunningham (6/1/2015)
Ed Wagner (6/1/2015)
crookj (6/1/2015)
Ed Wagner (6/1/2015)
Revenant (6/1/2015)
cunningham (6/1/2015)
TomThomson (6/1/2015)
Ed Wagner (6/1/2015)
AwayA-weigh
Anchors
News
Facts
Statistics
Lies
politicians
Corrupt
FIFA
Sport
Version
License
Cost
June 1, 2015 at 1:15 pm
tcronin 95651 (6/1/2015)
data, index, log and tempdb all on separate disks on new EMC SAN
More questions: Is the server a VM? Anything in the SAN logs?
😎
I've seen similar issues on...
June 1, 2015 at 1:14 pm
Ed Wagner (6/1/2015)
cunningham (6/1/2015)
Ed Wagner (6/1/2015)
cunningham (6/1/2015)
Ed Wagner (6/1/2015)
crookj (6/1/2015)
Ed Wagner (6/1/2015)
Revenant (6/1/2015)
cunningham (6/1/2015)
TomThomson (6/1/2015)
Ed Wagner (6/1/2015)
AwayA-weigh
Anchors
News
Facts
Statistics
Lies
politicians
Corrupt
FIFA
Sport
Version
June 1, 2015 at 12:56 pm
Viewing 15 posts - 5,116 through 5,130 (of 8,753 total)