Adding , Deleting and Updating a Column in a table
Many times we need to alter the table definition by adding , deleting or updating a column in the table. In...
2012-04-15
1,406 reads
Blog Posts
Derived Table In Sql Server
Derived tables:- Derived tables are the tables which are created on the fly with the help of the Select statement. It is...
2012-04-15
17,997 reads
Massively Parallel Processing and the Parallel Data Warehouse
Data growth is related to Moore’s law. As computers get faster and more powerful, we are using them to process...
2012-04-15
7,772 reads
New road to the SQL Server 2012 Certifications
MS has announced the new road for the SQL Server Certifications. All of the interested folks knows that the old...
2012-04-14
2,061 reads
Pivot and Unpivot table in SQL SERVER
Pivot Table:- Pivot tables are used to summarize and display the data, specially in case of report data by means...
2012-04-14
39,571 reads
So I started this blog…now what?
Date: May 19, 2012
Location: SQLSaturday #119, Chicago
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve started a blog...
2012-04-14
563 reads
Tech Days Albania 2012
I’m very excited for the invitation to present at TechDays Albania 2012, which will be held on April 19, 2012...
2012-04-14
1,826 reads
I am a Linchpin Team Mate
Linchpin People, LLC is an organization led by Brian Moran and Andy Leonard with Mike Walsh and Robert Pearl as...
2012-04-13
1,002 reads
I am speaking at #sqlsat111 on TEMPDB.
I was chosen to speak at SQL Saturday 111 in Atlanta GA this weekend. I will be doing my session...
2012-04-13
560 reads
Querying Microsoft SQL Server 2012 Beta exam (70-461 / 71-461) – My Thoughts
Well I’ve now done the final SQL Server 2012 exam I managed to get a slot booked for. The Querying...
2012-04-13
3,499 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers