Forum Replies Created
Viewing 15 posts - 7,681 through 7,695 (of 59,072 total)
-
Reply To: Toilets and Your Systems
jschmidt 17654 wrote:We had one of those radioed chiefs on USS Seahorse. "Commence Ventilating", then mistook the low pressure blow switches for the blower hull valve switches and we popped to...
-
Reply To: How to get specific database name for one common table
Do a search for "ms for each db sql server" and follow your nose to write some custom code.
-
Reply To: Toilets and Your Systems
John N Hick wrote:Dang - things weren't so complicated for us ground-pounders.
No? I think that getting shot at, possibly stepping into a hidden dung coated set of spikes, setting off a trip...
-
Reply To: Performance Issue After SQL 2019 Upgrade
+1,000,000 on that post, Grant.
-
Reply To: Toilets and Your Systems
Heh... No. I served on the USS Haddo (SSN 604), which almost went down twice in the same week because some newbie Chief (skimmer convertee) that they "radioed" the qual...
-
Reply To: Toilets and Your Systems
From the article:
One of the reasons I love history is because it really does teach us so much.
This is why old folks rock. It's not "history" to them... it's...
-
Reply To: Verify Server online status using sql server query
Mr. Brian Gale wrote:Hello Jeff,
Any update on that code? I am curious to look at it.
See attached.
There are 3 files in the ZIP file...
The...
-
Reply To: Distributing a value among the rows in Sql Server
Ok but, in the future, please help us help you by providing the sample data in a readily consumable format. Please see the first link in my signature line for...
-
Reply To: Always on
Admingod wrote:Thanks! Another question on same scenario, since Node1(Primary), Node2( secondary HA) and Node4(Secondary Reporting) are in the same location and Node3(Secondary Asynch DR) is in the DR location. Let's...
-
Reply To: Distributing a value among the rows in Sql Server
This is fairly easy to do but is doomed to failure because none of the columns can be used to preserve the order of the rows. There needs to be...
-
Reply To: Needed to find all possible Dates Overlaps from a single Table
Heh... I definitely blew that one then. I didn't look at the OPs code closely enough to realize that you had provided a copy of the same code. I was...
-
Reply To: Needed to find all possible Dates Overlaps from a single Table
Jonathan AC Roberts wrote:Jeff, Here is the data in a consumable format. I couldn't work out from the question exactly what's wanted so I'll leave it to someone else.
Except for a little...
-
Reply To: Optimize Cursor
Since you're using SQL Server 2016, this can probably be easily accomplished with LEAD/LAG. Help us help you... post the content of the tmpDeal01 table in a readily consumable format. ...
-
Reply To: How to run dynamic pivot table without using exec(sql statment)
Simply stated, I know of no way to create a dynamic pivot/crosstab without dynamic SQL and I know of no way to execute dynamic SQL without the use of EXEC.
I...
-
Reply To: Needed to find all possible Dates Overlaps from a single Table
Nice post and perfectly described but could you write the code without test data to know if you wrote the code correctly? Neither can we. 😉 Take the data you...
Viewing 15 posts - 7,681 through 7,695 (of 59,072 total)