|
|
-
sageata2002 incorrect 2 Years ago through Just Learned
If you come across the following error while running a T-SQL query or executing a stored procedure or in a SSIS package execution which states:
"The transaction log for database 'DatabaseName' is full. To find out why space in the log cannot be reuse...
|
-
sageata2002 incorrect 2 Years ago through Just Learned
If you come across the following error while running a T-SQL query or executing a stored procedure or in a SSIS package execution which states:
"The transaction log for database 'DatabaseName' is full. To find out why space in the log cannot be reuse...
|
-
sageata2002 Commented 2 Years ago through Just Learned
**TRUNCATE ONLY is EVIL!!!** As far as I know, it either has been removed, or it will be removed in a future version of SQL Server. Just to give you an example: you truncate the log, then something fails and you need to bring the database online to the ...
|
-
sageata2002 Commented 2 Years ago through Just Learned
**TRUNCATE ONLY is EVIL!!!** As far as I know, it either has been removed, or it will be removed in a future version of SQL Server. Just to give you an example: you truncate the log, then something fails and you need to bring the database online to the ...
|
-
sageata2002 Commented 2 Years ago through Just Learned
**TRUNCATE ONLY is EVIL!!!** As far as I know, it either has been removed, or it will be removed in a future version of SQL Server. Just to give you an example: you truncate the log, then something fails and you need to bring the database online to the ...
|
-
sageata2002 Answered 2 Years ago through Quizzes
Last time I knew about it, it was Jeffry Schwartz that introduced this concept, quite a while ago. But yes, Nupur, your husband has a great gift of explaining this not only in a more readable manner, but also in greater detail as compared with other aut...
|
-
sageata2002 Commented 2 Years ago through Just Learned
This is so NOT OK!!!! Brent Ozar had an article about this a while ago, and please believe me, that sub-second name resolution is not going to count much when doing the connection. As a bit of a challenge, think what happens when you change a) the IP ad...
|
-
sageata2002 Commented 2 Years ago through Just Learned
This is so NOT OK!!!! Brent Ozar had an article about this a while ago, and please believe me, that sub-second name resolution is not going to count much when doing the connection. As a bit of a challenge, think what happens when you change a) the IP ad...
|
-
sageata2002 Commented 2 Years ago through Just Learned
This is so NOT OK!!!! Brent Ozar had an article about this a while ago, and please believe me, that sub-second name resolution is not going to count much when doing the connection. As a bit of a challenge, think what happens when you change a) the IP ad...
|