Viewing 15 posts - 1,621 through 1,635 (of 6,676 total)
If the only values available in the result column are Y or N - you could do this:
Select r.id
From Response r
Group...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 5, 2020 at 4:20 pm
In contract to @JeffModen's response - it is also possible that the client(s) are sending varchar parameters and all of those queries are using implicit conversions and full index scans.
Before...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 3, 2020 at 7:26 pm
To find out why a step in a maintenance plan failed - you need to view the maintenance plan history - not the SQL Server Agent job history. To do...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 3, 2020 at 7:17 pm
Did you try running my example - or just the query? You need to change the example to fit your tables.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 1, 2020 at 8:50 pm
What account is running the SQL Server service? It seems that this account does not have access to read the local system to retrieve the list of available users.
Are you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 1, 2020 at 8:49 pm
I think this should get you started (thanks to pietlinden for the sample data):
--EquipWorkOrderID/DateTm/Equip/AccountCode/Descr/Description/Resolution/Status/UserNm/Hrs
Declare @WorkOrder Table (
EquipWorkOrderID INT
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 1, 2020 at 8:16 pm
I do not see any issues, but I would use developer edition.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 31, 2020 at 10:59 pm
So what part of the outline are you having a problem with? With as many different posts you have on this subject - I would have thought that you had...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 31, 2020 at 9:19 pm
If you create a text box parameter and allow any text to be entered by the user, then your SQL code could be as simple as:
SELECT ...
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 31, 2020 at 9:11 pm
First - to get row count you can do this instead of count:
Declare @schemaName sysname = 'dbo'
, @tableName sysname = 'Tally';
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 31, 2020 at 8:09 pm
You can start with something like this:
Declare @pDelimiter char(1) = ';';
Select tt.FileData
, p01_pos = p01.pos
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 29, 2020 at 4:35 pm
ROW_NUMBER() ???
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 29, 2020 at 4:02 pm
Yes - you can host the databases on a separate instance and install only the reporting services components on the 'web' server. This is quite useful if you are using...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 28, 2020 at 4:29 pm
All tables would have been modified with SSMS GUI.
DDIndexColumn was also been modified with the GUI yet has the correct Create Date.
This will depend on what changes were made...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 27, 2020 at 6:49 pm
This doesn't make sense - you already have a cluster built...across at least 2 servers (nodes)? And - you have setup an AG between 2 of those instances?
What you need...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 27, 2020 at 6:41 pm
Viewing 15 posts - 1,621 through 1,635 (of 6,676 total)