Viewing 15 posts - 256 through 270 (of 1,838 total)
Error message from application log from app team
=====================================================
Error connecting to database [
[Informatica][ODBC 20101 driver]7505
Database driver error...
Function Name : Connect
Database driver error...
Function Name : Connect
Database Error: Failed to connect to...
October 16, 2019 at 4:06 pm
if you compare the results with the ORDER BY t.start_Date and without, it might be clearer. Just having PARTITION BY t.customer_id will get the MAX(end_date) for each customer_id and return...
October 16, 2019 at 3:54 pm
An example is below, say you want to query how many orders your customers have, but include in the output customers who don't have any orders at all:
October 15, 2019 at 9:12 pm
If you aren't sure if the CPU usage is by SQL Server or something else, you can look in the ring buffer to see recent history:
DECLARE @ms_ticks...
October 15, 2019 at 9:08 pm
Does it store these states anywhere though?
State is not really a part of the error itself, but extra information that is added when RAISERROR is called that can help...
October 3, 2019 at 4:29 pm
I think what may be more important is to understand when to use transactions and how nested transactions affect the script. Typically you wouldn't put a single command within a...
October 2, 2019 at 3:37 pm
Where I'm at we do about 80% of our data warehouse work on premises and 20% in the cloud. I've worked in IT for 25 years, and it's important to...
October 2, 2019 at 3:19 pm
LOL pretty much. It really is shocking how many people still use varchar for dates and sql injection.....
Ugh... you had to bring up that memory for me! I had...
October 2, 2019 at 2:31 pm
I believe those are separate attributes of the user in active directory, they don't directly translate back and forth to each other, other than looking up the account by one...
September 30, 2019 at 7:43 pm
I believe that SQL Server logs are already text files. On your server, take a look at the following or equivalent folder:
C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log
The files named: ERRORLOG.* are the...
September 26, 2019 at 6:55 pm
The Blocked Process Threshold in SQL Server is measured in seconds, so the minimum would be 1 second. You'd have to shred the XML in the Blocked Process Report to...
September 25, 2019 at 8:02 pm
I doubt they will do that, but I was honestly surprised when they upped it to 10 GB. The biggest problem I see with on-site software licensing these days from...
September 24, 2019 at 4:24 pm
It is possible the database was upgraded to 2008 R2 from an older version that did already have BUILTIN\Administrators as a login. I don't think there is anything in the...
September 23, 2019 at 9:17 pm
In my opinion, for most people's purposes any RDBMS will suffice and they won't miss those extra features of Microsoft. If they have a new system they are evaluating what...
September 19, 2019 at 4:22 pm
I suppose the best way to think about it, WSFC is at the operating system level, and FCI is at the SQL Server level. You can have WSFC without FCI,...
September 3, 2019 at 3:58 pm
Viewing 15 posts - 256 through 270 (of 1,838 total)