How the Resource Governor Helped Our Report Server
Trying to manage the load in a reporting server can be hard. Roy Ernest shows that Resource Governor might be a great solution that has worked in his environment.
2010-06-28
5,682 reads
Trying to manage the load in a reporting server can be hard. Roy Ernest shows that Resource Governor might be a great solution that has worked in his environment.
2010-06-28
5,682 reads
There was a time when almost every Chapter leader were asking PASS to find a place where the leaders can...
2010-05-21
386 reads
It all started with Grant Fritchey (Twitter @GFritchey) posting on THE THREAD asking everyone if they are interested in writing...
2010-05-07
817 reads
Where ever you read, people claim that power shell is so easy that even a dummy can do it. Really?...
2010-03-08
620 reads
I am a nervous wreck today. Tomorrow we will have the first International speaker for our user group. Jimmy may...
2010-02-17
727 reads
This is wonderful news to our new chapter. Jimmy May has agreed to come to give a presentation at our...
2010-01-26
684 reads
Yesterday was the first time I gave a presentation to a group of professional who knows SQL Server. I was...
2009-12-04
791 reads
I have noticed that one of the best way to learn about a certain topic is to write an article...
2009-11-25
685 reads
It is said that you should not give direct table access (even select permission) to a user or group. But...
2009-11-25
521 reads
I am on my way in setting up a Pass chapter on our tiny Caribbean island. I had no clue...
2009-06-17
594 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
I've noticed several instances of what looks like a recursive insert with the format:...
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON INSERT dbo.TravelLog ( TravelLogID, CityID, StartDate, EndDate ) VALUES (25, 5, '2025-09-12', '2025-09-17') SET IDENTITY_INSERT dbo.TravelLog OFFI now run this code.
DBCC CHECKIDENT(TravelLog) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-10-14', '2025-10-17') GOWhat is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025? See possible answers