SSAS – Automatic Inventory Generation – 24 Columns – HTML Attachment
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2013-06-18
1,093 reads
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2013-06-18
1,093 reads
The scripting variables can be defined explicitly by using the setvar command or implicitly by using the sqlcmd -v option....
2013-06-12
1,887 reads
There are different ways to take Cube database backups.
SQL Agent JobXMLA script for backupROBOT jobASCMD commandSSIS PackageSSIS packageAMO (Analysis Management...
2013-06-11 (first published: 2013-06-05)
2,988 reads
One of my friend requested me to give a mutli server script to pull SQL Service related details. Here is...
2013-06-10
1,750 reads
One of SQL enthusiast asked me to include the complete code and wanted to schedule a SQL job. I’m trying...
2013-05-30
1,547 reads
This Post is a continuation of my previous post. Many times, there is a difficulty in pulling the data to...
2013-05-24
1,104 reads
There are many ways to execute SQL’s or T-SQL’s across listed SQL Instances. Most of us might have faced and...
2013-05-20
1,874 reads
We came across a scenario where database bak files being created from long time which are no more in use...
2013-05-17 (first published: 2013-05-13)
2,453 reads
One of my friend shared this content. I’m just sharing with you all.Good one and I like it pretty much!!!!Bill...
2013-05-16
625 reads
We are planning to take SSAS cube database backup since our backup tool does full file system backup in case...
2013-05-15
10,888 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132.. Fungsi Layanan:...
Call Cs 08218200233 Jl. Borobudur No.I, RT.03/RW.07, Mojolangu, Kec. Lowokwaru, Kota Malang, Jawa Timur...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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