Forum Replies Created
Viewing 15 posts - 346 through 360 (of 7,498 total)
-
Reply To: Scripting out AG code with Powershell
did you actually install SMO for SQL2016 ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: the while dont loop correctly to the end
that's because you don't start from the same set of data due to the "not exists" credential. ( which checks for existance in the target table !! )
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: temp table filtering with Joins question
It depends!
It would be more helpfull if you posted DDL for all involved objects.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: checkdbcc date for all database
... convert( desired_date_type, DATABASEPROPERTYEX(DB_NAME(), "LastGoodCheckDbTime")) ...
I've modified your script a little bit to be more informative :
CREATE TABLE #lastcheckdb
(
DbName sysname,
Updateability...Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: Need to output table data into multiple CSV files
Maybe not the most performant solution but as a next step import the full file and process it
$FullfileData = import-csv -Path $fullfile ;
$RecCounter = 0;
$TargetFileNo = 1;
$TargetFiletemplate...Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: High tempdb usage alternatives
As stated by the previous repliers, you must size your tempdb file(s) to be able to cope with your systems consumptions!
Things that may help out :
- grant your service account...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: post steps for Table PARTIONING
There are some red fags over here, especially with "just implementing partitioning in production"!
- 24/7
- 1h downtime / year
You need to prepare for this all !! As jeff statted, it...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: cost threshold for parallelism value to be set
Have a look at Grants page on the topic: Why You Should Change the Cost Threshold for Parallelism
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: Hello i am new to Sql and idk why i get this error and also not getting results.
Add the use of your database to your script. Chances are you are working in context of master database !
CREATE DATABASE dbsubjects;
USE dbsubjects;
CREATE TABLE tblstudent(...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: post steps for Table PARTIONING
Don't start your partitioning adventure in production !
Read this thoroughly : https://www.sqlservercentral.com/forums/topic/partition-large-tables-needed#post-4292250
ref Partitioned tables and indexes
ref Create partitioned tables and indexes
ref SQL Server Partitioning: Getting Started
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: Partition Large Tables needed
You can create different filegroups and different files on AzureSQLMI, you just cannot provide it with a filename !
Read Jeff's advice thoroughly!
Then decide...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: SQL Migration - Identifying Connections - Best approach
Server side trace will have the least impact.
Have look at the included sql file.
It needs a table in your DBA database. ( see script )
It creates 3 SQLAgent job:
- DBA_SQLTrace_7Zip...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: SQL Migration - Identifying Connections - Best approach
- You have not mentioned the version of the original SQL Server instance.
- For instances that do not support extended events, we used a (random) sampling methode to get a...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: Partition Large Tables needed
sqlguy80 wrote:.... SQL DB is on Azure MI, so only one file group is allowed....?
Have you tested that ?
CREATE DATABASE [MyPtDbOnSQLMI]
CONTAINMENT = NONE
GO
ALTER DATABASE [MyPtDbOnSQLMI]...Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: How to Setup Backups and Restore planning in SQL Server Availability Groups?
Have you taken a look at this: Configure backups on secondary replicas of an Always On availability group
or this ( and the following ): Understanding backups on AlwaysOn...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 346 through 360 (of 7,498 total)