Viewing 15 posts - 1 through 15 (of 367 total)
I stopped using % to grow files years ago. Microsoft even has an article saying what releases to use % and which to use actual amounts. I am actively looking...
June 15, 2021 at 3:19 pm
you could also set up a linked server see mssqltips.com articles on this,
If this is a real time transfer I think replication might be an option...
August 20, 2020 at 5:49 pm
When the tlog file grows it is because it is not getting backed up. Below is an article on index and log files .
August 20, 2020 at 3:13 pm
SSIS, SQL Server Integrated Services.
August 20, 2020 at 3:03 pm
# is a local temp table, ## is a global temp table, and left function pulls characters from a string, the person who wrote this is pulling 13.
https://www.mssqltips.com/sqlservertip/6035/local-vs-global-sql-server-temporary-tables/
August 20, 2020 at 2:21 pm
I know this post is a few years old but I wanted to share;
its just ="["+User!UserID+"]" you don't have to add the = "[Employee].[Employee_login_id].&[" + User!UserID + "]"...
October 11, 2018 at 12:44 pm
October 11, 2018 at 12:36 pm
October 11, 2018 at 12:35 pm
and I had some heap fragmentation, I had to add a clustered index drop it and run this query;
Alter
July 28, 2018 at 12:38 pm
I ran this little nugget and found what reports where still running. the server was overloaded with agent jobs and other people running long queries. Once everything settled down and...
July 28, 2018 at 12:26 pm
Not seeing any error in the log files. What should I look for in the executionlog3?
July 27, 2018 at 12:09 pm
October 16, 2017 at 3:11 pm
SELECT DISTINCT
t.GLStoreNum,
...
October 15, 2017 at 10:07 am
October 13, 2017 at 4:53 pm
Viewing 15 posts - 1 through 15 (of 367 total)