Forum Replies Created
Viewing 15 posts - 1 through 15 (of 56 total)
-
Reply To: Data Migration Assistant Sources
https://learn.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-ver15
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
Reply To: SQL Server 2022 Restore and DBCompat
Migrate to SQL Server 2022 (16.x)
You can migrate databases from older versions of SQL Server to SQL Server 2022 (16.x), as long as the source database compatibility level is 90 or higher....
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
Reply To: Read Only access to all databases to a user in a SQL Server Instance
Thanks, it is very useful!
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
Reply To: Checking Time
this system table may give diff. date time.
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
Reply To: Checking Time
SELECT DATEADD(SECOND, -sample_ms/1000, GETDATE()), *
FROM sys.dm_io_virtual_file_stats ( 1,1)
or
SELECT DATEADD(mi, -sample_ms/1000000, GETDATE()), *
FROM sys.dm_io_virtual_file_stats ( 1,1)
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
Reply To: Regenerating the Master Key
didn't show Maintenance Plans & Remote Maintenance Plans
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
Reply To: Zero or Hero?
Right, very interesting!
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
Reply To: An Empty NumPy Array
numpy.zeros(shape=(0,0)) also works
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
Reply To: Getting the time
<p id="ULjlONK">
</p>--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
Reply To: Getting the time
<p id="ULjlONK">
</p>--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
RE: Deterministic functions
PARSENAME system functions is deterministic per http://www.informit.com/articles/article.aspx?p=21329&seqNum=6 link
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
RE: Basic Python Lists
what SQLServer[1][1:5] will return?
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
RE: Testing Variables
if you are using the SQL module you can use $db.RecoveryModel = "Full", right?
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
RE: Interesting Datenames
run the script in sql2012 or sql2016, first time it return 2; run 2nd time it return 10.
but if you run this:SET LANGUAGE British
DECLARE @RunDate...--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
RE: Rounding Parameters
!
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
</p>
</p>Viewing 15 posts - 1 through 15 (of 56 total)