Viewing 15 posts - 1,471 through 1,485 (of 49,571 total)
Jeff Moden - Tuesday, May 2, 2017 2:21 PMDo you know how to stand up a VM?
Yes. Hyper-V, VirtualBox, VMWare Player,...
May 3, 2017 at 2:46 pm
May 2, 2017 at 6:33 am
May 2, 2017 at 5:11 am
the WHERE clause is used to filter out data. If you just need all the zip codes, in order, you just need
SELECT ZipCode
FROM Address
ORDER...
May 2, 2017 at 3:21 am
Worktables, hashes (sorts, aggregation), spools, etc. There's plenty of reasons why SQL would write data (and it'll be to TempDB) during execution of a query
May 2, 2017 at 3:08 am
Can you show us what the full results from that sample data set should look like?
At most two of each date in the columns?
PIVOT may work, but...
May 1, 2017 at 3:21 pm
Um..., ok. If you're testing that, you probably don't want the filter to only retrieve sessions that haven't done anything for two days, or it's going to be a very...
April 28, 2017 at 6:38 am
I've written a query to loop through a all the sleeping SPIDs and kill it...
April 28, 2017 at 6:20 am
April 28, 2017 at 6:18 am
April 27, 2017 at 3:07 pm
lkennedy76 - Tuesday, April 25, 2017 8:28 AMWill I switch the inventory_deafault file group back to the inventory table?
Huh? You don't switch...
April 27, 2017 at 8:16 am
ALTER TABLE SWITCH...
April 27, 2017 at 8:14 am
No. It has 2.9 billion rows (see the output of sys.dm_db_partiton_stats earlier)
April 27, 2017 at 8:11 am
tbh, I would recommend rather have 4 virtual servers, each with 16 cores and 1 instance of SQL Server 2012. You get far better seperation of resources (like memory) doing...
April 27, 2017 at 8:11 am
Viewing 15 posts - 1,471 through 1,485 (of 49,571 total)