What have you tried?

For scripting multiple tables to be trunctated it would be something like this:

TRUNCATE <Table1>;

TRUNCATE <Table2>;

TRUNCATE <Table3>;

TRUNCATE <Table4>;

--etc...

For...

I don't 100% understand your question but think that PATINDEX will help if you're asking what I think you're asking...

You want fields that only contain the letters A through G...

The best way would be to have a second parameter that allows the user to specify what they want (first day of the month, week, etc) then have the next...

First, Month and Year are terrible field names. Second, Splitting date attributes into separate columns is a bad idea.

Using your original sample data you could do this:

DECLARE @yourData AS...

I agree, no problem. Here's a good MSDN page that talks about what to look out for.

https://msdn.microsoft.com/en-us/library/ms143674(v=sql.110).aspx

I will add that anytime you upgrade your reports to a new version...

Yes, paging can be done in T-SQL. Below is some sample data and two examples of how to do it.

-- Sample Data

DECLARE @sales TABLE

(

sale_id int primary...

There is no WHERE clause in a SELECT statement. There is a WHERE clause in a SQL...

I would start with the The Microsoft Data Warehouse Toolkit, Second Edition: With SQL Server 2008[/url]

Great books for SSAS and MDX specifically are the "Step by Step" books.

SQLServerCentral...

How about...

WITH containsString AS (SELECT string FROM (VALUES ('% sports %'),('% exercise %'),('%toy%')) t(string))

SELECT DISTINCT c.Name

FROM Sales.Store c

JOIN containsString cs ON c.Name LIKE cs.string

Quick edit: Did not see Nevyn or...

That does seem like an odd requirement.

cppwiz (5/8/2015)

---

Let me suggest two alternatives to boot camps:

PASS Summit 2015

SQL Cruise[/url]

Neither of these will directly prepare you for certification, but they will give you a much broader learning opportunity....

For anyone out there experienced with SQLIO can you chime in on this thread. I'm still learning and am not the best resource on this. Thanks!

mxy (5/7/2015)

---

thanks Alan for your response. I have completed all the test runs with different block size, results see to be good (I don't know ;-))

ex for 8k block...

Interesting article. I learned something new this morning.

I just started working with SQLIO in the past couple months. I am no expert but found this article to be very helpful:

http://blogs.technet.com/b/josebda/archive/2013/03/28/sqlio-powershell-and-storage-performance-measuring-iops-throughput-and-latency-for-both-local-disks-and-smb-file-shares.aspx