Forum Replies Created
Viewing 15 posts - 211 through 225 (of 708 total)
-
RE: Availability Groups and SAN Replication
SAN replication of SQL Server database files is often just a way to spend money and corrupt databases. Way more people will promise a working solution than deliver one. SQL...
-
RE: I/O error 23(Data error (cyclic redundancy check)
I've seen that error when a bug with storage device has taken some sort of lock on a segment of data (as small as 32kb in some cases) and won't...
-
RE: COUNT(*) vs SUM()
That UNION is simply running the same query twice, and will produce them same value each time.
I'm guessing there's a WHERE clause you forgot. If all the data... -
RE: SQL Database corruption issue
john.round - Friday, August 18, 2017 2:47 AM -
RE: Core based Licensing and AWS SQL Licensing Question
If you're installing SQL Server, and not renting an image with it installed and licensed or paying to access a managed instance, then you bring your own licenses.
If...
-
RE: Design Distributed Availability group
Zeal-DBA - Monday, August 7, 2017 2:33 AM -
RE: Question about TABLOCKX and HOLDLOCK
Short answer:
To get the results you seek, replace the body of your stored procedure with a single step to update the value in the table and assign... -
RE: Problem with Linked Server Connection
Are you logging in with a SQL Server login or are you using Windows Authentication? If you are using a SQL Server login (which would throw the error you're seeing...
-
RE: Update Query Performance
sqlrob - Sunday, March 19, 2017 10:37 PMSample Blocking capture..
Thanks for that image, the details raise...
-
RE: Update Query Performance
GilaMonster - Thursday, March 16, 2017 5:26 AM -
RE: Update records and record the updated records into a table
With Composable DML, you can wrap the update call with the insert call, and avoid the #temp table completely.
Demo code (creates sample DB and table first):USE... -
RE: Will reducing max server memory setting need a reboot
sqlguy80 - Thursday, March 9, 2017 9:56 PM -
RE: Windowing function puzzle
You've basically hand-coded a DENSE_RANK() ... WHERE MAX(<DENSE_RANK() value>) = 2. The sample data will help roll a query to test, but you'll likely find a similar query plan with...
-
RE: Using XML Path in SQL Stored Procedure need URL
Just treat the href value as an attribute of the <a/> element, instead of turning the entire element into a string:
DECLARE
@URL varchar(100),
@GetData nvarchar(MAX)
SET @URL... -
RE: Composite clustering key
Simon E Doubt - Monday, February 27, 2017 2:54 PM
Viewing 15 posts - 211 through 225 (of 708 total)