Recently, I answered a question by a person on Experts Exchange.com on how to find the # of weekdays between two dates. This question was simplified greatly by the fact that the dates given would always be from Monday to Friday, and so the calculations needed were very simple.Then, while looking at the recent scripts […]
2004-11-22 (first published: 2004-11-10)
137 reads
This Function and the query will generate the script for Create / Drop/ Create Constraint based on a Naming Convention . More changes can be done on this. This is very simple
2004-11-18 (first published: 2004-11-05)
214 reads
A better version of the :"Finding first/last day of month by a date"
2004-11-17 (first published: 2004-11-04)
148 reads
backup log with truncate only doesn't shrink the file. Actually truncating log needs transaction to truncate. A simple way to reduce the log file size to 1KB.
2004-11-16 (first published: 2004-11-03)
554 reads
create this SQL as a stored procedure and give user execute permissions on it store procedure. that user will be able to see all the jobs and their associated schedules but won't be able to modify, create or execute job. This is particularly a request most often aske dby developer to view jobs/schedules on production […]
2004-11-15 (first published: 2004-10-29)
640 reads
some times after restore database, you find your logins and users mapping is lossed and no user can now logon to database using application. I faced that many times. To map all your database users with master..syslogins. save this procedure in current database and execute it. All users will be mapped with logins.
2004-11-12 (first published: 2004-10-29)
392 reads
SP_WHO_3 is a very powerful utility for all DBAs. It displays processes connected to the system and what they are doing. It can find blocking processes, can return the Input Buffer for everything in the recordset returned, and provides immense filtering and sorting capabilities. It's designed to be extremely efficient, yet it provides many more […]
2004-11-09 (first published: 2004-08-05)
909 reads
Allows specification of a database whose properties are to be listed. Allows showing properties by category (Null, false, or true).
2004-11-08 (first published: 2004-08-07)
928 reads
2004-11-05 (first published: 2004-08-08)
1,704 reads
The situation arises when we are displaying data in a grid or some other control at front end level, where the user is making corresponding changes in the grid and at last when the user click for update button, the whole changes should be posted back to the database. This can be achieved by two […]
2004-11-04 (first published: 2004-08-10)
552 reads
The DBA life is fraught with pain. Those battles that we endure are mostly...
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Hello, I would like to ask whether it is technically possible to redirect a...
WA:08218154393 Jl. Brigjen Katamso No.183, Keparakan, Kec. Mergangsan, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55121
WA:08218154393 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Can I set Accelerated Database Recovery on tempdb?
See possible answers