Very nice. 🙂

No, it does not search against indexes. You would need to add that to the script unfortunately.

I would have to agree with Lee on this one, just because of pressure it could put on the server.

Thanks Lee. 🙂

Unfortunately, without having access to your environment I cannot say for sure. What does it show if you run this on the database in question:

EXEC sp_spaceused

Latest version with a bunch of changes now available. 🙂

New version coming soon! Changes:

1. Extended "Deployment" Logic

2. Extended "Computer Pick" Logic

3. Reworked "Ocean Grids Display" Code

Well done! Glad you liked it. 🙂

below86 (7/3/2014)

---

I've noticed a pattern in the shots the computer takes, at least on my server. Does that mean I played it too much?:-) Shots start out with...

andrei_solntsev (6/30/2014)

---

Also I recommend to use PIVOT to display a grid. Try this

SET @Loop_Player = 0;

WHILE @Loop_Player <= 1 ...

Scott.Skinner (6/30/2014)

---

This seems to work OK. Many ways to solve it.

UPDATE

date_calendar

SET

quarter_weekdays_remaining =

(

SELECTISNULL( SUM( r.is_weekday ), 0 )

FROMdate_calendar r

WHEREr.calendar_date > s.calendar_date

ANDr.calendar_year = s.calendar_year

ANDr.calendar_quarter = s.calendar_quarter

),

quarter_weekdays_completed =

(

SELECTISNULL( SUM( c.is_weekday ),...

andrei_solntsev (6/30/2014)

---

That's ok. It is possible to rewrite code to use different rules.

For example, you may define Ship_Definitions table as

IF OBJECT_ID (N'tempdb.dbo.#temp_Ship_Definitions', N'U') IS NULL

BEGIN

CREATE TABLE dbo.#temp_Ship_Definitions

...

andrei_solntsev (6/29/2014)

---

Hi Sean,

Great program, I had a lot of fun playing and analyzing it.

The only problem I found is that ship placement is not random enough which makes it easy...

Scott.Skinner (6/27/2014)

---

Ran the script and it is very nice. One problem is that I am getting stange results for the quarter_weekdays_remaining and quarter_weekdays_completed fields. On 2001-09-01 and 2009-09-02 my table...

Moneer-479830 (6/20/2014)

---

Hi, I am trying to search a string from the object definitions like this and getting no result

EXECUTE dbo.usp_Object_Search

@Search_String = N'fiscal/2'

...