Viewing 15 posts - 1 through 15 (of 117 total)
The current place I work we have to get 2 week advance notice for anything that requires a schema lock on any of the busier tables. Granted we are still...
September 2, 2019 at 10:02 am
Unfortunately my friend trying to stop this problem before it happens is like trying to ice skate uphill. Database Developers and DBA job requisitions are usually created once the damage...
December 14, 2016 at 5:15 am
When using EF/Linq2SQL, I always use method calls to stored procedures to do any CRUD work.
Any tool that treats logical and physical models as the same thing is asking...
May 17, 2016 at 12:19 pm
Got it i had a feeling I was missing something. Need my morning coffee :w00t:
March 8, 2016 at 6:29 am
If you know referential integrity is being enforced, why query the Departments table at all if you're not returning any data from it? If you are not returning any columns...
March 8, 2016 at 5:57 am
Just in case anyone was curious, here's how it turned out:
I have to provide two connection strings, one for ADO.Net (with MultiSubnetFailover) and one for OleDb.
I use the ADO.Net connection...
July 1, 2015 at 4:19 pm
Joie Andrew (6/26/2015)
Not sure about your second question but for getting the primary instance with an Execute SQL task could you not just run the following?
SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS');
This doesn't provide the...
June 29, 2015 at 10:01 am
So pretty much we're stuck with either Script Task or Derived Columns?
October 15, 2014 at 4:05 pm
Alvin, I agree, but that makes it difficult to troubleshoot and debug when you might have some transformation in the source SQL query, but other transformations in the SSIS itself....
October 14, 2014 at 11:24 am
You mention OLTP In-Memory tables help with CPU bottlenecks - do you have any further details/reference material on this?
September 16, 2014 at 1:42 am
I think this might be pointing me in the right direction. Thank you
September 8, 2014 at 7:36 pm
Hugo Kornelis (6/28/2014)
For clustered indexes only, SQL Server will add an internal 4-byte value to provide uniqueness.
Hate to be a stickler here, but I've heard the 4-byte number thrown...
June 28, 2014 at 8:38 am
Daniel - no offense, but when I read these articles I want to actually learn something, not hear a soapbox speech about the software made by the parent company of...
June 26, 2014 at 4:34 am
e4d4 (7/3/2013)
Why
ALTER DATABASE DbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE;....
this leaves one connection which block yours restore, try this
ALTER DATABASE DbName SET offline WITH ROLLBACK IMMEDIATE;....
I swear I tried...
July 3, 2013 at 8:14 am
SQLSACT (7/3/2013)
Might be a silly question, are you connected to the database in question when running these commands?
I am using master database. But you raise a good point, for me...
July 3, 2013 at 7:13 am
Viewing 15 posts - 1 through 15 (of 117 total)