Viewing 15 posts - 1,516 through 1,530 (of 2,458 total)
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...
-- Itzik Ben-Gan 2001
May 11, 2015 at 10:02 am
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...
-- Itzik Ben-Gan 2001
May 11, 2015 at 9:51 am
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...
-- Itzik Ben-Gan 2001
May 11, 2015 at 9:33 am
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...
-- Itzik Ben-Gan 2001
May 11, 2015 at 9:23 am
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...
-- Itzik Ben-Gan 2001
May 10, 2015 at 9:53 pm
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...
-- Itzik Ben-Gan 2001
May 10, 2015 at 9:38 pm
Are the [predicates] the columns in the WHERE clause of a SELECT statement?
There is no WHERE clause in a SELECT statement. There is a WHERE clause in a SQL...
-- Itzik Ben-Gan 2001
May 8, 2015 at 5:50 pm
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...
-- Itzik Ben-Gan 2001
May 8, 2015 at 3:46 pm
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...
-- Itzik Ben-Gan 2001
May 8, 2015 at 3:18 pm
My question is why do you care how many rows of each column have NULL?
That does seem like an odd requirement.
-- Itzik Ben-Gan 2001
May 8, 2015 at 10:09 am
cppwiz (5/8/2015)
Neither of these will directly prepare you for certification, but they will give you a much broader learning opportunity....
-- Itzik Ben-Gan 2001
May 8, 2015 at 9:20 am
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!
-- Itzik Ben-Gan 2001
May 8, 2015 at 9:04 am
mxy (5/7/2015)
ex for 8k block...
-- Itzik Ben-Gan 2001
May 8, 2015 at 9:00 am
Interesting article. I learned something new this morning.
-- Itzik Ben-Gan 2001
May 8, 2015 at 7:39 am
I just started working with SQLIO in the past couple months. I am no expert but found this article to be very helpful:
-- Itzik Ben-Gan 2001
May 7, 2015 at 10:21 am
Viewing 15 posts - 1,516 through 1,530 (of 2,458 total)