Forum Replies Created
Viewing 15 posts - 106 through 120 (of 179 total)
-
RE: Top Skills in 2018 for Data Professionals
Grant Fritchey - Monday, January 8, 2018 5:23 PMYes, definitely one of the top 10 must-have skillz for DBA's.
I got all... -
RE: Is This Data Science?
Rod at work - Tuesday, January 9, 2018 9:14 AM -
RE: store data changes(insert\update\delete)
Lynn Pettis - Friday, January 5, 2018 9:37 AMExtended...
-
RE: Execute Process Task
Please check the account SSIS is running under. It could be a permission issue. Just a hunch.
-
RE: Top Skills in 2018 for Data Professionals
Lynn,
This is for entertainment only and that is why I posted it in "Anything that is NOT about SQL!" category.
-
RE: STORED PROCEDURE
doug.brown - Monday, January 8, 2018 4:12 PMRE: I have to get a count of orders placed between 1 pm yesterday and 1 pm today by day
Sue_H - Monday, January 8, 2018 3:14 PMRE: I have to get a count of orders placed between 1 pm yesterday and 1 pm today by day
SELECT CAST(OrderDate AS DATE) AS [Date], COUNT(1) AS [Count]
FROM [OrderTable]
GROUP BY CAST(OrderDate AS DATE)
ORDER BY COUNT(1) DESCRE: Top Skills in 2018 for Data Professionals
Allow me give a hint. Do you see the trend here?
RE: Learn about data in a datawarehouse
There is no easy way to help you understand the ER. In a DW setting, chances are that you will see a typical set of queries that run frequently. You may...
RE: Can not kill this session
Assuming that you have tried to terminate the session using 'kill spid', I run into this issue from time to time. You need to see what the session is doing...
RE: Powershell Script for regular DBA activities_GenerateScripts
What is I want to script a long list of tables but not all tables?
It would be helpful if you could allow user to populate a target file with...RE: Error 17054 severity 16 state 1- SQL Server Automatically Restarts
Would you are to share a more complete error log? Was there memory dump in the log? OS and SQL version info, processor type, memory size?
RE: Splitting TempDB across multiple files
Thanks. I shall remember to provide more details. I'll start recording PLE changes from now on.
Windows Server 2016 Standard Ed, 256GB Physical Memory. 24 Logical Processors
SQL Server...RE: STORED PROCEDURE
Bluntly speaking, your code requires lots of improvement.
1. Your Step 1 will totally screw up the result because you are assigning DOLA and GI to two variables....Viewing 15 posts - 106 through 120 (of 179 total)
