Using the Timestamp Data Type - SQL School Video
The timestamp data type is a unique data type in SQL Server. Brian Knight shows how it can be used in your tables.
2009-01-29
4,557 reads
The timestamp data type is a unique data type in SQL Server. Brian Knight shows how it can be used in your tables.
2009-01-29
4,557 reads
It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.
2009-01-27
5,133 reads
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
2009-01-22
4,417 reads
After you complete an upgrade to SQL Server 2008, Brian Knight goes over some things you might want to do first.
2009-01-08
3,258 reads
Not every option in SQL Server is useful or appropriate. Brian Knight shows which ones you might not wish to mess with.
2009-01-06
6,268 reads
Learn the basics of how to work with Management Studio in this SQL School video.
2009-01-01
8,121 reads
There are times that you want to determine quickly if any data has changed. Brian Knight shows how checksums can be used in T-SQL.
2008-12-18
6,135 reads
In the second part of this basic video on MDX queries, MVP Brian Knight continues with his discussion of MDX, examining some more advanced MDX features.
2008-12-11
6,743 reads
MDX is the query language for multidimensional queries, usually against SSAS cubes. Brian Knight introduces us to the basics of MDX in this video.
2008-12-09
9,170 reads
MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.
2008-12-04
4,445 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers