Rebuild Indexes of database with fragmentation more than 30%
Rebuild of indexes is the prime job of a DBA as heavily fragmented indexes can degrade query performance and cause your application...
2015-04-29 (first published: 2015-04-18)
17,748 reads
Azhar Iqbal
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
When I right click on the database diagrams folder in SSMS to create new diagram. Following popup window open with error.
Solutions:
From the Message you can clearly see that the...
2014-02-25
71 reads
Attach Database “Operating System Error 5 (Access is denied)” MSSQL Server 2012.
When I try to attach mdf file I got following error below.
Solution:
There are multiple solutions to this
1 1. Move .mdf and .ldf to SQLServer install directory Data folder...
2014-02-20
69 reads
Create Database Error "operating system error 112(There is not enough space on the disk.)"
I try to create database by generating script of another database, which was a huge Database. When I run the script below
USE [master]
GO
CREATE DATABASE [YourDB] ON PRIMARY
( NAME...
2014-02-18
95 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Magetan Hub/Wa. 0817-819-444
Jl. A. Yani No.25 B, Dusun Onggoprayan, Kepolorejo, Kec. Magetan, Kabupaten Magetan, Jawa Timur...
Layanan BCA KCU MADIUN Hub/Wa. 0817-819-444
9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers