SQL Example:
DECLARE @TableRowsCount table
(
Tablename varchar(50),
cnt int)
insert into @TableRowsCount
EXEC sp_MSforeachtable @command1=” select ‘?’,count(*) from ?”
select * from @TableRowsCount
PowerShell Example:
Load SQL PowerShell by...
2013-04-11
1,148 reads
A tweet from Ted Krueger (Blog | @Onpnt) this morning…
I’m surrounded by BI people!!!!#passbac
— Ted Krueger (@onpnt) April 11, 2013
inspired a little creativity…
You...
2013-04-11
776 reads
Like many of us, I have a collection of favorite movies. These include Ghostbusters, Stripes, Serenity, and dozens more. I...
2013-04-11
776 reads
We all know that we should document our SQL Servers, right? RIGHT?
So let's say you had some time on...
2013-04-24 (first published: 2013-04-11)
3,813 reads
Change Database name of a below mentioned query
DECLARE @cntr_value1 bigint
DECLARE @cntr_value2 bigint
SELECT ‘BEFORE’
SELECT @cntr_value1 = cntr_value
FROM sys.dm_os_performance_counters
WHERE counter_name = ‘transactions/sec’
AND object_name = ‘SQLServer:Databases’
AND...
2013-04-11
625 reads
Replace a valid server name in the following examples. Try to do a testing on your local machine and understand...
2013-04-11
3,372 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-04-23 (first published: 2013-04-11)
3,340 reads
SELECT create_date as ‘SQL Server Install Date’ FROM sys.server_principals WHERE name=’NT AUTHORITY\SYSTEM’
2013-04-10
700 reads
#Description : List all the files of a local or remote drive, run this PowerShell script using PowerShell-ISE.exe for better execution...
2013-04-10
737 reads
Usually named instance can uses dynamic port, if firewall setup on the server, you can use SQL Server Configuration Manager...
2013-04-18 (first published: 2013-04-10)
5,095 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers